update t1
set amount = sum(b.amount)
from ts b
where a.id=b.id
On Thursday 18 January 2001 09:54, Carolyn Wong wrote:
> 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