Dominique Devienne wrote: > On Wed, Nov 6, 2013 at 2:45 PM, Igor Tandetnik <i...@tandetnik.org> wrote: > > ... g left join r on (g.g_id = r.g_id and r.m_id = :mypid) ... > > Nitpick: I'd put r.m_id = :mypid in a separate where clause, rather than > being on the join's ON clause. At least that's the way I'd write it (I'm > assuming it's equivalent)
It is *not* equivalent with a LEFT join: when there is no 'mypid' match, you still get that group in the result. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
