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) > 0?


I tried both of these and neither worked. These queries work in SQL Server.

Worth 500 points.

Thanks,
Rick
richardsimnettAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
delete table1.*
from table1 , table2
where table1.something = table2.something


http://dev.mysql.com/doc/refman/5.0/en/delete.html
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.