Received: from mail1.waterford.org (mail1.waterford.org [205.124.117.6]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f7GKC0P20073 for ; Thu, 16 Aug 2001 16:12:00 -0400 (EDT) (envelope-from olebedev@waterford.org) Received: from waterford.org ([205.124.117.234]) by mail1.waterford.org (Netscape Messaging Server 3.56) with ESMTP id 307 for ; Thu, 16 Aug 2001 14:02:59 -0600 Message-ID: <3B7C2CFA.2B57616C@waterford.org> Date: Thu, 16 Aug 2001 14:28:42 -0600 From: Oleg Lebedev X-Mailer: Mozilla 4.72 [en] (Windows NT 5.0; U) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Nested JOINs Content-Type: text/plain; charset=koi8-r Content-Transfer-Encoding: 7bit X-Archive-Number: 200108/219 X-Sequence-Number: 4451 Hello, I am trying to execute an SQL query that contains nested joins, but I get parser error for some reason. Below is the query I am trying to execute and the error I am getting: SELECT media FROM (dtrowmedia a INNER JOIN dtrow b ON (a.dtrow = b.objectid)) c INNER JOIN dtcol d ON (c.dtcol = d.objectid) psql: ERROR: parser: parse error at or near "inner" Note that the following query executes with no errors: SELECT media FROM dtrowmedia a INNER JOIN dtrow b ON (a.dtrow = b.objectid) INNER JOIN dtcol d ON (b.dtcol = d.objectid) What am I doing wrong? Please help me get it to work. Thanks Oleg