SELECT b.BEACTIVE,a.BEACTIVE,a.*
--UPDATE a
-- SET a.BEACTIVE = b.BEACTIVE
FROM STAFFDOC AS a
INNER JOIN Skzy_Main.dbo.STAFFDOC AS b ON a.ENTID = b.ENTID AND a.STAFFID = b.STAFFID AND a.USERID = b.USERID
WHERE a.ENTID ='E2SVHJM7RVQ'
SELECT b.BEACTIVE,a.BEACTIVE,a.*
--UPDATE a
-- SET a.BEACTIVE = b.BEACTIVE
FROM STAFFDOC AS a
INNER JOIN Skzy_Main.dbo.STAFFDOC AS b ON a.ENTID = b.ENTID AND a.STAFFID = b.STAFFID AND a.USERID = b.USERID
WHERE a.ENTID ='E2SVHJM7RVQ'