Home Forums Article Discussions Article Discussions by Author Discuss content posted by aditya UPDATE RE: UPDATE
geervani
SSC Enthusiast
Points: 146
More actions
September 24, 2009 at 1:02 am
#1057879
The answer for the question is YES. FROM clause can be used in UPDATE query. But the example query given is wrong.
something like this will work
update table1
set coulmn=a2.column
from table1 as a1, table2 as a2
where a1.colum1 = a2.column2