I have two tables (Roommates, Applicants) and want to delete records from Roommates where field name Roommate Name matches field name Roommate Name in Applicants. Tried using the below but am asked for parameter value when I run it. I just want it to recognize ALL matches and automatically delete those records. Any advice would be appreciated.
DELETE*
FROM ROOMMATES
WHERE(ROOMATES.ROOMMATENAME=APPLICANTS.ROOMMATENAME)
DELETE*
FROM ROOMMATES
WHERE(ROOMATES.ROOMMATENAME=APPLICANTS.ROOMMATENAME)