update help - Mailing list pgsql-sql

From Carolyn Wong
Subject update help
Date
Msg-id 3A665AE3.CE43178B@greatpacific.com.au
Whole thread Raw
Responses Re: update help  (Tubagus Nizomi <nizomi@dnet.net.id>)
Re: update help  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: "tjk@tksoft.com"
Date:
Subject: Re: Select 'Sunday' in month ??
Next
From: Tubagus Nizomi
Date:
Subject: Re: update help