Re: [SQL] update help

[Tubagus Nizomi]

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