DELETE FROM With a Subquery

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);

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: