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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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