SQL-SERVER , UPDATE A TABLE BASED ON ANOTHER TABLE

علی ذوالفقار
1402/08/23 07:18:47 (109)

UPDATE T1 
    SET T1.COL1 = T2.COL2 
FROM TBL_1 T1 
INNER JOIN TBL_2 T2 
    ON T1.ID = T2.ID

Back