[SQL] update help

[Carolyn Wong]

I'd like to know what's the correct SQL statement to do the following:

update  t1 a
set     a.amount = sum(b.amount)
from    t2 b
where   a.id = b.id