只需在DELETE和FROM之间添加要删除记录的表的名称，因为我们必须指定要删除的表。还要删除ORDERBY子句，因为删除记录时没有要排序的内容。

因此，您的最终查询应该如下所示：

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

这是我的SQL Server版本

DECLARE @ProfileId table(Id bigint)

DELETE FROM AspNetUsers
OUTPUT deleted.ProfileId INTO @ProfileId
WHERE Email = @email

DELETE FROM UserProfiles    
WHERE Id = (Select Id FROM @ProfileId)

试试看：

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

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

DELETE FROM users WHERE id IN(
    SELECT user_id FROM Employee 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'

只需在DELETE和FROM之间添加要删除记录的表的名称，因为我们必须指定要删除的表。还要删除ORDERBY子句，因为删除记录时没有要排序的内容。

因此，您的最终查询应该如下所示：

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