Skip site navigation (1) Skip section navigation (2)

adding missing FROM-clause

From: "Colin Gillespie" <C(dot)Gillespie(at)newcastle(dot)ac(dot)uk>
To: "PostGreSQL" <pgsql-novice(at)postgresql(dot)org>
Subject: adding missing FROM-clause
Date: 2004-10-27 09:47:44
Message-ID: 20DA376D0C991745A4D5249F7BCD7A250D380F@largo.campus.ncl.ac.uk (view raw or flat)
Thread:
Lists: pgsql-novice
Dear All,

I have a simple join query 

SELECT c1 FROM t1 
INNER JOIN 
t2 ON t2.c2 = t1.c2 WHERE t3.c3= t2.c3;

Which gives the expected result but I get the message
NOTICE:  adding missing FROM-clause entry for table "t3"

How do I get rid of this NOTICE, i.e. how should I construct my select query.

Many thanks

Colin


pgsql-novice by date

Next:From: Kjetil HaalandDate: 2004-10-27 11:59:56
Subject: using palloc in extension functions in c
Previous:From: Michael GlaesemannDate: 2004-10-27 09:43:33
Subject: Re: Cannot Create tables - on Windows XP

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group