thanks, BareFeet. I will give this a try tomorrow. Igor,
I tried to reply to your email, but somehow, I can not reply to newsgroup. Weird. But, the relationship is login. thanks, josé ----- Original Message ----- From: "BareFeet" <[EMAIL PROTECTED]> To: "General Discussion of SQLite Database" <[email protected]> Sent: Tuesday, October 28, 2008 6:43 PM Subject: Re: [sqlite] Combined Select Statement > Hi José, > >> 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. > > Assuming that the tables are related by the "Login" column/field, then > you to join then, such as: > > select X.Login, X.Name, Y.Internal from X left join Y on X.Login = > Y.Login > > Tom > BareFeet > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
