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)