我想在**SQL Server 2008中使用 "INNER JOIN "来删除。
但我得到这个错误。
Msg 156, Level 15, State 1, Line 15 关键字'INNER'附近的语法不正确。
我的代码。
DELETE FROM WorkRecord2
INNER JOIN Employee ON EmployeeRun=EmployeeNo
WHERE Company = '1' AND Date = '2013-05-06'
这可能对你有帮助吗?
DELETE FROM dbo.WorkRecord2
WHERE EmployeeRun IN (
SELECT e.EmployeeNo
FROM dbo.Employee e
WHERE ...
)
或者试试这个 -
DELETE FROM dbo.WorkRecord2
WHERE EXISTS(
SELECT 1
FROM dbo.Employee e
WHERE EmployeeRun = e.EmployeeNo
AND ....
)