Igor Tandetnik wrote:
>
>
> select table1.id, table2.date
> from table1 left join table2 on (table1.id = table2.id);
>
>
Thanks, You beat me to it.
And for those who don't have a clue what a "left join" is (this was me 2
days ago)
It includes all of the entries from the "left" table (even if there are no
entries on the "right table), matched with the entries that are on the
"right" table.
--
View this message in context:
http://old.nabble.com/Multi-table-select-tp29356401p29363582.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
