sql update select 

1 UPDATE A SET A1 = B1, A2 = B2, A3 = B3 FROM A, B WHERE A.ID = B.ID
2 UPDATE A  SET A1 = B1, A2 = B2, A3 = B3  FROM A LEFT JOIN B ON A.ID = B.ID

 

posted @ 2024-08-20 17:17  。活着。  阅读(13)  评论(0)    收藏  举报