[thelist] MySQL: Problem with JOIN query

[Tab Alleman]

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. 

A, 

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
operator.