Hi, I think that: Nevermind.. I figured it out. I needed a left join.
does not cut it as a sollution. We new bees whant a complete solution to learn. Like the complete sql statement that you used to solve your probleme. thanks Guy -------------------------------------------------- From: "taftech" <taft...@gmail.com> Sent: Thursday, August 05, 2010 8:55 PM To: <sqlite-users@sqlite.org> Subject: Re: [sqlite] Multi table select > > Nevermind.. I figured it out. > > I needed a left join. > > > > taftech wrote: >> >> I have two tables that I want to select data from >> >> For example >> table1 has one column "id" which has 100 entries >> >> table2 has two column "id" and "date" >> the "id" columns match >> table2 has 1000 entries, but only 50 of them match with table1 >> >> is there a way I can do a single select that will pull all 100 columns >> from table1 and have the data info for the 50 that are in table2? >> >> I tried doing select table1.id,table2.date from table1,table2 where >> table1.id=table2.id >> >> but I realized that only selects the records that exist in both databases >> >> Thanks >> > > -- > View this message in context: > http://old.nabble.com/Multi-table-select-tp29356401p29356402.html > Sent from the SQLite mailing list archive at Nabble.com. > > _______________________________________________ > 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