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