On Jan 4, 2012, at 4:01 PM, Igor Tandetnik wrote: >> Unfortunately, looks like this query will filter out actors that have >> performed in only that one movie > > Just change the last two joins to LEFT JOIN.
And the where clause. And perhaps add an explicit group by. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users