geervani (9/24/2009)
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
Yes, I wasn't sure which way to answer since the syntax wasn't quite right.