MY SQL Delete with Inner Join
Posted on 2014-02-16
HI, I have a query below which basically finds duplicates email addresses across 2 tables. The results of this I would like to delete from the em_exclusion table. I.e for every row that is returned from the below query I would like to delete from the exclusion table any row that has an email address duplicate with the em_subscriber table.
I have googled around for this and watched YouTube videos and cant find anything on deleting the results of an "Inner Join"
select * from activecampaign.em_exclusion
Inner join activecampaign.em_subscriber
ON em_exclusion.email = em_subscriber.email