Delete, Update using Subquery

DELETE FROM dbo.TableA
FROM dbo.TableA et
INNER JOIN
DatabaseA.dbo.TableB AS tu
ON
tu.TeamId=et.TeamId AND tu.UserId=et.UserId
WHERE tu.IsDeleted=1


UPDATE TempFull
SET ALY_ID=cac.ALY_ID
FROM
TempFull t
INNER JOIN
CODAnalysisCode cac
ON
t.AnalysisCode=cac.ALYCode
WHERE t.ALY_ID IS NULL