mysql select question

[friday]

I have two tables in my mysql database:

table 1: admin_menu_een
fields: ID, naam, mapnaam

table 2: admin_menu_twee
fields: ID,naam,mapnaam,menu_een_ID
(The "menu_een_ID" field refers to the ID field of the "admin_menu_een" table)


How do I select all records from admin_menu_een AND admin_menu_twee, except for the records from admin_menu_een whose ID is entered in admin_menu_twee.menu_een_ID ?

[ExtraDog]

SELECT
ID, naam, mapnaam
FROM
admin_menu_een
WHERE
ID NOT IN(SELECT DISTINCT menu_een_ID FROM admin_menu_twee)
UNION
SELECT
ID, naam, mapnaam
FROM
admin_menu_twee

[friday]

Thanks a bunch!