Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 2D2C99FB228 for ; Wed, 17 Jan 2007 08:55:39 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 28523-03 for ; Wed, 17 Jan 2007 08:55:17 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id 69BD29FB223 for ; Wed, 17 Jan 2007 08:55:22 -0400 (AST) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=phlogiston.dydns.org) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1H7ATo-0007OY-Ho for pgsql-sql@postgresql.org; Wed, 17 Jan 2007 08:05:28 -0500 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id AE33141A2; Wed, 17 Jan 2007 07:55:11 -0500 (EST) Date: Wed, 17 Jan 2007 07:55:11 -0500 From: Andrew Sullivan To: pgsql-sql@postgresql.org Subject: Re: Update query by joining multiple tables. Message-ID: <20070117125511.GC19527@phlogiston.dyndns.org> References: <82e1a9bd0701170320j14d4ebdagd66d8c9f095b0192@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <82e1a9bd0701170320j14d4ebdagd66d8c9f095b0192@mail.gmail.com> User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/67 X-Sequence-Number: 27219 On Wed, Jan 17, 2007 at 04:50:18PM +0530, Moiz Kothari wrote: > http://www.postgresql.org/docs/8.1/interactive/sql-update.html, it is not > specified if a join can be done between multiple tables to update a table, i Sure it is: A list of table expressions, allowing columns from other tables to appear in the WHERE condition and the update expressions. a -- Andrew Sullivan | ajs@crankycanuck.ca Users never remark, "Wow, this software may be buggy and hard to use, but at least there is a lot of code underneath." --Damien Katz