What is the SQL statement for a Delete Query where the objective is to delete the records in a table that are equal to the records in another table that is joined to it? For example, you have a table that contains phone numbers of opportunity seekers joined to a table that contains phones numbers of people who have opted out of being contacted. So the objective is to delete the records in the table of opportunity seekers if their phone number is also in the table of opt outs.
Here is the SQL statement from the same query in Access:
DELETE [Text-Connects].*
FROM [Text-Connects]
INNER JOIN [Text-Removals] ON [Text-Connects].Mobile = [Text-Removals].Mobile;