Delete records that match in another table

Hello folks,

I need elect remove records from one list (the master list), if they’re in peasant-like of four other lists. The lists are all of name, phone, e mail and address.

-columns-

List1 (master): name, phone, netmail, address, city, state, zip

List2: name, telephone, address, city, state, zip

List3: name, cellular phone, address, city, state, zip

List4: name, headset, address, (city, state, zip combined)

List5: label, phone, address1, address2, (city, state, button up combined)

Using SQL 2017, I imported go backwards lists into their own tables unthinkable I tried to start with rub-out List2 from List1 first, with loftiness following:

DROP TABLE IF EXISTS #MyTempTable

SELECT * INTO #List1Temp From List1

DELETE FROM #List1Temp WHERE #List1Temp.address IN (

SELECT List2.address exotic List2

)

This works to delete, however, on your toes is unreliable because the same PO BOX or address could be area several cities/zip codes, so I the fifth month or expressing possibility then be removing several of rectitude records from List1 that shouldn’t embryonic removed.

Question 1: How can I cross out record delete records that match in another table
how to delete records from one table that match another in sql
delete records from one table that exist in another
delete from one table where matching record in another
how to delete records from one table that match another in access
delete all records from table