----------------------------------------- -- Delete "Removed" Items ----------------------------------------- DELETE FROM tblMenuGroups WHERE MenuText IN ( SELECT [Group], MenuText, Visible FROM (SELECT tblMenuGroups.[Group], tblMenuGroups.MenuText, tblMenuGroups.Visible, tblMenuStructure.MenuText AS MenuTextFilter FROM tblMenuGroups LEFT OUTER JOIN tblMenuStructure ON tblMenuGroups.MenuText = tblMenuStructure.MenuText ) UnMatched WHERE MenuTextFilter IS NULL ) dl>OMG, I can't believe I missed that! Thank you so much.