From: Carolyn Wong <carolyn@greatpacific.com.au>
To: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: update help
Date: Thu, 18 Jan 2001 13:54:27 +1100
Message-ID: <3A665AE3.CE43178B@greatpacific.com.au> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: carolyn@greatpacific.com.au
Subject: Re: update help
In-Reply-To: <3A665AE3.CE43178B@greatpacific.com.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox