Example: Join Condition DELETE - Analytics Database - Teradata Vantage

This example deletes rows from the employee table for employees who work in NYC. This operation joins the employee and department tables in the WHERE clause predicate:

     DELETE FROM employee
     WHERE employee.deptno = department.deptno
     AND department.location = 'NYC';