SQL Query To Delete With Join

Posted by Barnaby Knowles on 5 March 2010, 11:25 pm

Usually our SQL queries use JOINs in SELECT queries. But what about if you want to DELETE using a JOIN? It’s not as straightforward.

You Have To Use A *

To tell MySQL which table you want to delete records from you must specify table.* like so:

DELETE product.*
FROM product p
LEFT JOIN productPrice pp
ON p.productId = pp.productId
WHERE pp.productId is null

Further details and examples can be found at Cross Table Delete with MySQL.