<div>
Perfect thanks was missing that extra line much appreciated
</div>


Perfect thanks was missing that extra line much appreciated

<div>
Hi, <br />
Use this statement to delete emails<br />
DELETE activecampaign.em_exclusio<wbr />n, activecampaign.em_subscrib<wbr />er from table_name1,table2 <br />
where (select * from activecampaign.em_exclusio<wbr />n inner join activecampaign.em_subscrib<wbr />er ON em_exclusion.email=em_subs<wbr />criber.ema<wbr />il)
</div>


Hi,
Use this statement to delete emails
DELETE activecampaign.em_exclusion, activecampaign.em_subscriber from table_name1,table2
where (select * from activecampaign.em_exclusion inner join activecampaign.em_subscriber ON em_exclusion.email=em_subscriber.email)

<div>
<div class="content wysiwyg-content">
HI, &nbsp;I have a query below which basically finds duplicates email addresses across 2 tables. &nbsp;The results of this I would like to delete from the em_exclusion table. &nbsp;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.<br />
<br />
I have googled around for this and watched YouTube videos and cant find anything on deleting the results of an &quot;Inner Join&quot;<br />
<br />
select * from activecampaign.em_exclusio<wbr />n<br />
Inner join activecampaign.em_subscrib<wbr />er<br />
ON em_exclusion.email = em_subscriber.email<br />
<br />
<br />
Thanks &nbsp;all
</div>
</div>


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


Thanks  all

MY SQL Delete with Inner Join

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.