DELETE FROM With a Subquery

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 = 
What is the corresponding DELETE statement for this?

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


Recent Articles: