cross check

[jaymc]

I have a simple query where I am using a join to pull out all usernames from a members table where the field propic is equal to 0

 

That works fine, however I must also check to see if their username and type != 'emailed' on a third table

 

Its checking the 3rd table thats causing me problems.

 

If there is no username|emailed row in the 3rd table I want it to pull out there username, otherwise return no match

 

SELECT m.username
	FROM members m
	INNER JOIN cache c on m.username = c.username
	LEFT JOIN email_log e ON m.username = e.username
	WHERE
	c.propic = '0' AND e.type != 'emailed'

 

[fenway]

If you're LEFT JOINing, you need to make any where clause conditions pertaining to the left join'ed table to the on clause.