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