Nested JOINs

From: Oleg Lebedev <olebedev(at)waterford(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: Nested JOINs
Date: 2001-08-16 20:28:42
Message-ID: 3B7C2CFA.2B57616C@waterford.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Mark Stosberg 2001-08-16 20:34:41 Re: Re: Help!!! Trying to "SELECT" and get a tree structure back.
Previous Message Jeff Eckermann 2001-08-16 19:21:56 Re: Interval FAQ - please review