我想用SQL Server 2008中的INNER JOIN
来表示delete.
但我有一个错误:
Msg 156, Level 15, State 1, Line 15
Incorrect syntax near the keyword 'INNER'.
我的代码:
DELETE
FROM WorkRecord2
INNER JOIN Employee
ON EmployeeRun=EmployeeNo
WHERE Company = '1'
AND Date = '2013-05-06'