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

TAGS : | | | |