ERROR: missing FROM-clause entry for table - Mailing list pgsql-general

From bigkev
Subject ERROR: missing FROM-clause entry for table
Date
Msg-id 1455088283643-5886750.post@n5.nabble.com
Whole thread Raw
Responses Re: ERROR: missing FROM-clause entry for table
Re: ERROR: missing FROM-clause entry for table
Re: ERROR: missing FROM-clause entry for table
List pgsql-general
I am receiving this error for the query pasted below.
Is the LEFT JOIN on the table not enough?
What needs to happen here?
I am guess something to do with derived tables

http://pastie.org/10715876



--
View this message in context: http://postgresql.nabble.com/ERROR-missing-FROM-clause-entry-for-table-tp5886750.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: Josh berkus
Date:
Subject: Re: PostgreSQL vs Firebird SQL
Next
From: David Grelaud
Date:
Subject: Re: PostgreSQL vs Firebird SQL