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

Filed under:
|
|

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

Related posts about php

Related posts about mysql