I am importing data from a paradox table and trying to clean it up. I have this query that finds all the child records that are not in the parent table.Select MemberID FROM memtype AS a WHERE NOT EXISTS (SELECT * FROM members AS b WHERE a.MemberID IN (b.MemberID));
Now I'm trying to delete all those child records instead of just selecting them so I tried...Delete MemberID FROM memtype AS a WHERE NOT EXISTS (SELECT * FROM members AS b WHERE a.MemberID IN (b.MemberID));
Sql clearly doesn't like this. What am I doing wrong?Thanks,Stacy