Subject Update with data FROM a table
Author m_formigoni
Hello again,

I'm trying to do an update in a table using data from another table,
like this:

update TABLE
set FIELD1 = T2.FIELD1,
from TABLE2 T2
where TABLE.ID = T2.ID

It raises the following error: "Invalid token FROM".

Once more: I used to do this in Sybase...

Does anybody knows how can I do this without declaring variables?