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-tp29356401p29356401.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