Help with Where clause and Left Join

[ichini]

Hello,

 

Is there a way to limit a where clause to only one half of a join?

 

Here's my code:

$query = "SELECT * FROM achievements LEFT JOIN list_achievements ON achievements.name = list_achievements.entry WHERE listname = '$listname' AND username = '$username' order by achievements.name";

 

However, I only want the "WHERE listname = '$listname' AND username = '$username'" to apply to list_achievements and NOT to achievements. In other words, I want to select only the rows that I want out of list_achievements and join them to the full achievements table.

 

Is this possible?

 

Thanks for any help!

 

Edit: (oops, this should have been in the mysql section I guess, sorry)

[JonnoTheDev]

SELECT * FROM achievements LEFT JOIN list_achievements ON (achievements.name = list_achievements.entry AND listname = '$listname' AND username = '$username') ORDER BY achievements.name