发布日期:2018-03-26
如何在SQL Server中使用“INNER JOIN”语句来删除?+ 查看更多
如何在SQL Server中使用“INNER JOIN”语句来删除?
+ 查看更多
发布日期:2018-02-24 16:43
分类:SQL
浏览次数:190
我想在SQL Server 2008中使用“INNER JOIN”语句来删除。
但是我得到了这样的错误:
但是我得到了这样的错误:
Msg 156, Level 15, State 1, Line 15 ncorrect syntax near the keyword 'INNER'.
我的代码:
DELETE FROM WorkRecord2 INNER JOIN Employee ON EmployeeRun=EmployeeNo WHERE Company = '1' AND Date = '2013-05-06'
回答
您需要指定要从中哪个表中删除,以下是具有别名的版本:
DELETE w FROM WorkRecord2 w INNER JOIN Employee e ON EmployeeRun=EmployeeNo WHERE Company = '1' AND Date = '2013-05-06'