adding missing FROM-clause - Mailing list pgsql-novice

From Colin Gillespie
Subject adding missing FROM-clause
Date
Msg-id 20DA376D0C991745A4D5249F7BCD7A250D380F@largo.campus.ncl.ac.uk
Whole thread Raw
List 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:

Previous
From: "Paul Daniels"
Date:
Subject: using postgreSQL with MS-IIS and eGroupWare
Next
From: Reinhard Hnat
Date:
Subject: Re: ERROR: INSERT has more target columns than expressions