如下图:
解决办法:
UPDATE b
SET b.Beactive ='N'
FROM BUSINESSDOC AS a
INNER JOIN SUPPLYDOC AS b ON a.EntId = b.EntId AND a.BusinessId = b.SuppliersId
WHERE CHARINDEX('删除',a.BusinessName,0) > 0
UPDATE a
SET a.Beactive ='N'
FROM BUSINESSDOC AS a
INNER JOIN SUPPLYDOC AS b ON a.EntId = b.EntId AND a.BusinessId = b.SuppliersId
WHERE CHARINDEX('删除',a.BusinessName,0) > 0