SQL Server 通过左连接和分组进行更新

Question

我正在更新我们的数据库，并且想要更新另一个表中没有现有项目的行。我可以将表连接在一起，但无法对表进行分组以获取行数

UPDATE dpt
SET dpt.active = 0 
FROM DEPARTMENT dpt
LEFT JOIN DOCUMENTS doc on dpt.ID = doc.DepartmentID
GROUP BY dpt.ID
HAVING COUNT(doc.ID) = 0

我应该做什么？

Answer 1

使用：

UPDATE DEPARTMENT
   SET active = 0 
 WHERE NOT EXISTS(SELECT NULL 
                    FROM DOCUMENTS doc
                   WHERE doc.departmentid = id)

Answer 2

UPDATE  department
SET     active = 0
WHERE   id NOT IN
        (
        SELECT  departmentId
        FROM    doc
        )