PHP - Moved: Inner Join Issue

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=308855.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=320476.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=355951.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=332358.0

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

Code: [Select]
$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";