[sqlite] Combined Select Statement

[jose isaias cabrera]

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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users