LEFT JOIN is NULL issue

[mcmuney]

What's wrong with the statement below? I'm not getting any results, but I know for a fact that there should be results. What I'm trying to do is this: Take ALL id's from table member, then compare it with table member_images and display ONLY the id's that DOES NOT exist in member_images

 

$sel_mem="SELECT id FROM member AS members LEFT JOIN member_images AS images ON members.id = images.id WHERE members.id IS NULL LIMIT 5";	

[sunfighter]

Try this:

SELECT * FROM member
LEFT OUTER JOIN member_images
ON member.id = member_images.id
WHERE member_images.id IS null

[AyKay47]

Then the table on the right is not returning a match with the table on the left, which will set the right table values to null. You want an outer join.

[sunfighter]

I think I said that AyKay47, didn't I?

[AyKay47]

no, you said "Try this:" which doesn't teach the OP anything. I said in english what you wrote in code.