sql - 如何使用 SQL Server 的 INNER JOIN 进行删除？

Question

我想在 SQL Server 2008 中使用 INNER JOIN 来删除。

但我收到此错误:

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'

Answer 1

您需要指定要从中删除的表。这是带有别名的版本:

DELETE w
FROM WorkRecord2 w
INNER JOIN Employee e
  ON EmployeeRun=EmployeeNo
WHERE Company = '1' AND Date = '2013-05-06'