2012/03/01 19:56 -0800, Don Wieland
I do not get the same results. Am I missing something? Hopefully
something simple ;-)
O, you are. You do not want GROUP_CONCAT in the subquery. It gives you the
comma-separated string whereto you referred, which, as far as the IN goes, is
o
Yes it is possible and you only need to use LEFT join if you need all of
the records from "issues" whether there are records in users that match or
not.
Just JOIN the users table TWICE and assign each one it's own alias, like
this:
SELECT
FROM issues i
INNER JOIN users u1
on u1.id
