Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f151AAx36805 for ; Sun, 4 Feb 2001 20:10:10 -0500 (EST) (envelope-from josh@agliodbs.com) Received: from [209.10.40.250] (account ) by davinci.ethosmedia.com (CommuniGate Pro WebUser 3.3) with HTTP id 1186399 for ; Sun, 04 Feb 2001 17:10:07 -0800 From: "Josh Berkus" Subject: JOIN chaining not working in 7.1 beta 3 To: pgsql-sql@postgresql.org X-Mailer: CommuniGate Pro Web Mailer v.3.3 Date: Sun, 04 Feb 2001 17:10:07 -0800 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit X-Archive-Number: 200102/35 X-Sequence-Number: 1203 Tom, Stephen, I'm trying to parse a query like the following and keep getting various errors (I'd give you the real query but &%^$# Netscape won't do cut-and-paste): SELECT a.1, b.2, c.14, a.2, c.5 FROM a INNER JOIN b ON a.1=b.3 LEFT OUTER JOIN c on a.1=c.2; And I get: ERROR: JOIN/ON CLAUSE REFERS TO 'c' WHICH IS NOT PART OF JOIN. What's wrong here? -Josh Berkus ______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