Example: Join Condition DELETE - Advanced SQL Engine - Teradata Database

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