Quick Links

ERROR: missing FROM-clause entry for table

From:	bigkev <kevin(dot)waterson(at)gmail(dot)com>
To:	pgsql-general(at)postgresql(dot)org
Subject:	ERROR: missing FROM-clause entry for table
Date:	2016-02-10 07:11:23
Message-ID:	1455088283643-5886750.post@n5.nabble.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	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.

Responses

Re: ERROR: missing FROM-clause entry for table at 2016-02-10 07:44:26 from Michael Paquier
Re: ERROR: missing FROM-clause entry for table at 2016-02-10 07:45:09 from Charles Clavadetscher
Re: ERROR: missing FROM-clause entry for table at 2016-02-10 08:02:33 from Roxanne Reid-Bennett

Browse pgsql-general by date

	From	Date	Subject
Next Message	David Grelaud	2016-02-10 07:40:59	Re: PostgreSQL vs Firebird SQL
Previous Message	Josh berkus	2016-02-10 07:06:15	Re: PostgreSQL vs Firebird SQL