Question:
How can I delete all data from a table using a join?For example, the SELECT statement would be: SELECT * FROM Master AS A, Detail AS B WHERE A.price > 100 AND B.id = A.id
What is the corresponding DELETE statement for this?
Answer:
If your database supports the standard for subqueries in the DELETE FROM statement, you can construct it this way:
DELETE FROM Detail WHERE id IN (SELECT id FROM Master WHERE price > 100);