Mysql - Join matches and non-matches
Posted
by jwzk
on Stack Overflow
See other posts from Stack Overflow
or by jwzk
Published on 2010-04-05T17:57:43Z
Indexed on
2010/04/05
18:03 UTC
Read the original article
Hit count: 151
This is related to my other question: http://stackoverflow.com/questions/2579249/managing-foreign-keys
I am trying to join the table of matches and non-matches.
So I have a list of interests, a list of users, and a list of user interests.
I want the query to return all interests, whether the user has the interest or not (should be null in that case), only where the user = x. Every time I get the query working its only matching interests that the user specifically has, instead of all interests whether they have it or not.
© Stack Overflow or respective owner