Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f3QHiP370094 for ; Thu, 26 Apr 2001 13:44:25 -0400 (EDT) (envelope-from josh@agliodbs.com) Received: from [207.172.28.154] (HELO agliodbs.com) by davinci.ethosmedia.com (CommuniGate Pro SMTP 3.4.1) with ESMTP id 44554 for pgsql-sql@postgresql.org; Thu, 26 Apr 2001 10:44:24 -0700 Message-ID: <3AE85E1E.2D39D02D@agliodbs.com> Date: Thu, 26 Apr 2001 10:42:54 -0700 From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions X-Mailer: Mozilla 4.73 [en] (Win98; I) X-Accept-Language: en MIME-Version: 1.0 To: sqllist Subject: No JOINs in UPDATE ... FROM? Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200104/409 X-Sequence-Number: 2771 Folks, In 7.1 RC2, I've been trying to use the following JOIN syntax: UPDATE assignments SET status = -1 FROM assignments JOIN orders ON assignments.order_usq = orders.usq WHERE orders.status = -1; However, I get an error of "Relation assignments referenced twice in query." Now, I can (and have) re-phrase the query so that PostgreSQL will accept it. However, I was under the impression that the above was standard SQL92. Am I mistaken? Or is this form something that just hasn't been implemented yet? -Josh -- ______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete information technology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco