update join, delete join

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13

   
UPDATE t1
    
SET t1.CalculatedColumn = t2.[Calculated Column]
    
FROM dbo.Table1 AS t1
    
INNER JOIN dbo.Table2 AS t2
    
ON t1.CommonField = t2.[Common Field]
    
WHERE t1.BatchNo = '110';
  

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11

  
DELETE a
  
from t0 a
  
JOIN t1 b
  
ON a.c0=b.c0
  
WHERE b.c1='xxx'