如何在SQL Server中使用INNER JOIN进行删除？

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

但我得到了这个错误：

消息156，级别15，状态1，第15行关键字“INNER”附近的语法不正确。

我的代码：

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

当前回答

试试看：

DELETE FROM WorkRecord2 
       FROM Employee 
Where EmployeeRun=EmployeeNo
      And Company = '1' 
      AND Date = '2013-05-06'

2013-05-10 17:37:22

其他回答

试试看：

DELETE FROM WorkRecord2 
       FROM Employee 
Where EmployeeRun=EmployeeNo
      And Company = '1' 
      AND Date = '2013-05-06'

2013-05-10 17:37:22

尝试此查询：

DELETE WorkRecord2, Employee 
FROM WorkRecord2 
INNER JOIN Employee ON (tbl_name.EmployeeRun=tbl_name.EmployeeNo)
WHERE tbl_name.Company = '1' 
AND tbl_name.Date = '2013-05-06';

2014-07-16 10:16:43

应该是：

DELETE zpost 
FROM zpost 
INNER JOIN zcomment ON (zpost.zpostid = zcomment.zpostid)
WHERE zcomment.icomment = "first"

2014-08-17 08:15:09

您甚至可以执行子查询。喜欢下面的代码：

DELETE FROM users WHERE id IN(
    SELECT user_id FROM Employee WHERE Company = '1' AND Date = '2013-05-06'
)

2020-09-01 18:28:45

以下是我当前用于删除甚至更新的内容：

DELETE           w
FROM             WorkRecord2   w,
                 Employee      e
WHERE            w.EmployeeRun = e.EmployeeNo
             AND w.Company = '1' 
             AND w.Date = '2013-05-06'

2017-02-22 14:50:17

如何在SQL Server中使用INNER JOIN进行删除？

推荐文章

最新文章

标签