Joel Peshkin <bugreport at peshkin.net> wrote: > LEFT JOIN cc ON cc.bug_id = bug.id AND cc.who = davesuserid > WHERE cc.who IS NULL Won't this just return 0 results? cc.who can't be both davesuserid and NULL at the same time.