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 

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