delete from inner join sql
DELETE WorkRecord2 FROM WorkRecord2 INNER JOIN Employee ON EmployeeRun=EmployeeNo WHERE Company = '1' AND Date = '2013-05-06';
Source: stackoverflow.com
sql delete join
DELETE P FROM Product P LEFT JOIN OrderItem I ON P.Id = I.ProductId WHERE I.Id IS NULL