<div>
<div class="content wysiwyg-content">
Hello, 
How do I join two tables together for a delete? 
 
ie: 
 
delete from table1 
from table1 inner join table2 
on table1.something = table2.something 
 
or 
 
delete from table1 
from table1 inner join table2 
one INSTR(table1.something,table2.something) &gt;&nbsp;0? 
 
 
I tried both of these and neither worked. These queries work in SQL Server. 
 
Worth 500 points. 
 
Thanks, 
Rick
</div>
</div>

Hello,
How do I join two tables together for a delete?

ie:

delete from table1 
from table1 inner join table2
on table1.something = table2.something

or 

delete from table1
from table1 inner join table2
one INSTR(table1.something,table2.something) > 0?


I tried both of these and neither worked. These queries work in SQL Server.

Worth 500 points.

Thanks,
Rick

Delete on inner join?

Hello,
How do I join two tables together for a delete?

ie:

delete from table1 
from table1 inner join table2
on table1.something = table2.something

or 

delete from table1
from table1 inner join table2
one INSTR(table1.something,table2.something) &gt; 0?


I tried both of these and neither worked. These queries work in SQL Server.

Worth 500 points.

Thanks,
Rick

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.