I have a Unmatched query that displays what I need but I want to clean up my database and remove them but its not letting me. See sql below.
I changed "Delete" it was "Select" thinking that would work but it does not. Also see screen shot.
Code:
DELETE Warranty
FROM Warranty LEFT JOIN Serials_Repair ON Warranty.[Serial] = Serials_Repair.[Serials_Repair]
WHERE (((Serials_Repair.Serials_Repair) Is Null));
I changed "Delete" it was "Select" thinking that would work but it does not. Also see screen shot.