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
