UPDATE first_table t1
set (t1.column3, t1.column4, t1.column5, ...) = (
SELECT t2.column3, t2.column4, t2.column5, ...
from second_table t2
where t1.column1=t2.column1 and t1.column2=t2.column2
)
No comments:
Post a Comment
NO JUNK, Please try to keep this clean and related to the topic at hand.
Comments are for users to ask questions, collaborate or improve on existing.