Sql to delete record from table

[101287]

Need to do a query to delete records in a table if there is a match in another table.

Try the code below but it does not work. Any suggestions.

DELETE jsfAccountManagerDetail.jsfRequirement, *
FROM jsfAccountManagerDetail, amReqXreftlb
WHERE (((jsfAccountManagerDetail.jsfRequirement)=[amReqXreftlb]![Number ]));

Thank you, Luis

 

[Golom]

DELETE *
FROM jsfAccountManagerDetail
WHERE jsfRequirement IN (Select [Number] From amReqXreftlb);

 

[101287]

Thank you. It works!