How to Delete using INNER JOIN with SQL Server?

Question

I want to delete using INNER JOIN in SQL Server 2008.

But I get this error:

Msg 156, Level 15, State 1, Line 15

Incorrect 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 1

Use this query along with the alias name:

DELETE w

FROM WorkRecord2 w

INNER JOIN Employee emp

ON EmployeeRun=EmployeeNo

WHERE Company = '1' AND Date = '2013-05-06'

 Note: You must specify what table are you deleting from.