[thelist] MySQL: Problem with JOIN query

Tab Alleman Tab.Alleman at MetroGuide.com
Mon Mar 1 08:54:47 CST 2004

Joshua Olson wrote:

> In order to do this you'll need to join users against
> user_interest_assoc twice.  One interest will be matched off the
> first join and the second interest will be matched off the second
> join. 


Are you using a version of MySQL that supports subselects?  I know with
MSSQL you can get an even faster solution with subselects and the EXISTS

More information about the thelist mailing list