how about just change the WHERE clause to :
WHERE reports_signup.user_id != '2' (or whatever user_id)
ie: does not equal.
That should grab all reports they are not signed up for and the left join
will include all reports that nobody is signed up for (left-overs).
Another issue is that you're
Ack .. ignore the part of my last post re the original query not working :)
... it will as the user_id column will be null for reports notbody has and
this will fail the where clause my mistake. the LEFT join is redundant,
however, and the replacement I posted will also work ...
Anyway -
USING NOT IN will exclude reports that nobody has ... which I'm not sure is
the outcome he was after - It was my first thought as well but the actual
solution (assuming reports someone isn't signed up for includes reports that
nobody is signed up for) is quite simple I think - just change the
