// // This query will delete all the employee-ID // records off of the phone number table that don't // have a matching primary key on the employee table // DELETE FROM "tbl_Emp-Phn-Original" WHERE "employee-ID" IN ( SELECT DISTINCT "EMP-PHN"."employee-ID" FROM "tbl_Emp-Phn-Original" AS "EMP-PHN" WHERE "EMP-PHN"."employee-ID" NOT IN (SELECT "EMP"."employee-ID" FROM "tbl_Employees" AS "EMP" ) )