Delete records from a table where records match criteria in another table

[scr5jo]

Hi,



I want to delete some records in a table where there is a match on a field in that table to a field in another table.
here is my sql code, but access is not accepting it,

DELETE FROM [20 Demand with identifier]
WHERE [20 Demand with identifier].CustomerVendor
IN (
SELECT [15 CustomerVendor].CustomerVendor
);

can anyone help me get the correct code?

[June7]

DELETE FROM [20 Demand with identifier]
WHERE [20 Demand with identifier].CustomerVendor
IN (SELECT [15 CustomerVendor].CustomerVendor FROM [15 CustomerVendor]);