Guy (Hotmail) <[email protected]> wrote: > 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.
select table1.id, table2.date from table1 left join table2 on (table1.id = table2.id); Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

