Greetings!
I have two tables:
CREATE TABLE X
(
login primary key,
Name,
Password,
...,
ProjOwned
);
CREATE TABLE Y
(
login primary key,
Internal,
...,
Place
);
What I would like to do is to create a select statement that will bring,
X.Login,X.Name,Y.Internal
as the result in one row. I have a select statement with union but it comes
in two rows, plus union wants me to pair the selection. I would like to
have it in one row.
Any help would be greatly appreciated.
thanks,
josé
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
