More LEFT JOIN Headaches

Please help -- by brain is fried... I have three tables: groups, members, and a link table called group_members. There is a record in group_members for each member that belongs to a given group. A member may belong to several group. I want to get a results set that shows all members where a

Re: More LEFT JOIN Headaches

I don't think you really want a LEFT JOIN. (See http://www.mysql.com/doc/en/JOIN.html). What you do need, I believe, is a join of group_members with itself to get member IDs on one side whose group ID matches Jim's group ID on the other side. Try something like this: mysql SELECT

More LEFT JOIN Headaches

: More LEFT JOIN Headaches Please help -- by brain is fried... I have three tables: groups, members, and a link table called group_members. There is a record in group_members for each member that belongs to a given group. A member may belong to several group. I want to get a results set