On 23 Sep 2011, at 12:57pm, Igor Tandetnik wrote: > select name, > (select count(*) from people where course=courses.id), > (select count(*) from tasks where course=courses.id) > from courses;
Thank you thank you thank you Igor. I must learn how to use sub-selects properly. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users