• Developer Zone
• Lists Home
• FAQ

I need to list items in a table that do not have a corresponding item in a
related table.
The table 'forum' contains the complete list, the table 'msg' contains
'orphaned' items. The tables are linked with field 'id'.
I looked in the archive and tried this based on a posting I found:

select forum.id from forum left join msg using (id) where msg.id=NULL limit
5;

This query gives an empty result set, while a record with id=1 exists in
'forum' but not in 'msg' (so '1' is an item in the desired result set).

What is the correct SQL statement ?