On 11/6/2013 8:50 AM, Dominique Devienne wrote:
On Wed, Nov 6, 2013 at 2:45 PM, Igor Tandetnik <i...@tandetnik.org> wrote:
select g_id, :mypid,
(case when r.p_id is null then 'no' else 'yes' end) is_member
from g left join r on (g.g_id = r.g_id and r.m_id = :mypid);
order by (r.p_id is null), g_id;
Nitpick: I'd put r.m_id = :mypid in a separate where clause, rather than
being on the join's ON clause.
That would filter out all 'no' rows. Try it, see for yourself. With an
outer join, ON and WHERE clauses are not interchangeable.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
