Friday, 3 April 2015

Update Table w.r.t. another table Key

UPDATE table2
SET table2.col1 = table1.col1,
table2.col2 = table1.col2,
...
FROM table1, table2
WHERE table1.memberid = table2.memberid




This email has been checked for viruses by Avast antivirus software.
www.avast.com

No comments:

Post a Comment