Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UPDATE TABLE1 A
- SET A.COL1= (SELECT DISTINCT B.COL1 FROM TABLE2 B WHERE B.ID= A.ID AND B.DeptID=104)
- WHERE A.DeptID=3
- UPDATE TABLE1 A
- SET A.COL1 = B.COL1
- FROM TABLE2 B
- WHERE
- A.ID = B.ID AND
- A.DeptID = 3 AND
- B.DeptID = 104;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement