How to Delete using INNER JOIN with SQL Server?
I want to delete using
INNER JOIN in SQL Server 2008.
But I get this error,
Msg 156, Level 15, State 1, Line 15
ncorrect syntax near the keyword 'INNER'.
My code:
DELETE FROM WorkRecord2
INNER JOIN Employee ON EmployeeRun=EmployeeNo
WHERE Company = '1' AND Date = '2013-05-06'Answer :
You need to specify what table you are deleting from, here is a version with an alias:
DELETE w
FROM WorkRecord2 w
INNER JOIN Employee e
ON EmployeeRun=EmployeeNo
WHERE Company = '1' AND Date = '2013-05-06'
http://stackoverflow.com/questions/16481379/how-to-delete-using-inner-join-with-sql-server
