SQL

sql delete join

DELETE P
  FROM Product P
  LEFT JOIN OrderItem I ON P.Id = I.ProductId
 WHERE I.Id IS NULL

delete from inner join sql

    DELETE WorkRecord2 
      FROM WorkRecord2 
INNER JOIN Employee 
        ON EmployeeRun=EmployeeNo
     WHERE Company = '1' 
       AND Date = '2013-05-06';

delete join sql server

DELETE P
FROM target_profile_tbl P
LEFT JOIN target_tbl I ON P.id = I.profile_id
WHERE I.id = (SELECT profile_name FROM target_profile_tbl WHERE profile_name = '')