Page 3 of 3

Posted: Sat Aug 26, 2006 12:45 pm
by timvw
Just analyze your query... You're requesting stuff where users.user_id equals awards.award_id... Even in the case it would return something it would probably not be what you want...

more expected joins are:

user.user_id = awards.user_id
user_awards.award_id = awards.ward_id
user_awards.user_id = user_id