Posted: Sat Aug 26, 2006 12:45 pm
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
more expected joins are:
user.user_id = awards.user_id
user_awards.award_id = awards.ward_id
user_awards.user_id = user_id