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

Reply via email to