The following example deletes employees from the employee table using a join on the employee and department tables.
DELETE employee FROM department AS d, employee WHERE employee.dept_no = d.dept_no AND salary_pool < 50000;
The following example deletes employees from the employee table using a join on the employee and department tables.
DELETE employee FROM department AS d, employee WHERE employee.dept_no = d.dept_no AND salary_pool < 50000;