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