Nested JOINs
От | Oleg Lebedev |
---|---|
Тема | Nested JOINs |
Дата | |
Msg-id | 3B7C2CFA.2B57616C@waterford.org обсуждение исходный текст |
Ответы |
Re: Nested JOINs
Re: Nested JOINs |
Список | 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
В списке pgsql-sql по дате отправления: