Example: Join Condition DELETE With Derived Table Subquery - Analytics Database - Teradata Vantage

The following example uses a subquery to perform the same action as Example: Join Condition DELETE With FROM Clause and Correlation Name and Example: Join Condition DELETE With No FROM Clause.

     DELETE FROM employee
     WHERE dept_no IN (SELECT dept_no
                       FROM department
                       WHERE salary_pool < 50000);