adding missing FROM-clause - Mailing list pgsql-general

From C G
Subject adding missing FROM-clause
Date
Msg-id BAY15-F5qpEq8hZYNX60004235c@hotmail.com
Whole thread Raw
Responses Re: adding missing FROM-clause  ("Uwe C. Schroeder" <uwe@oss4u.com>)
Re: adding missing FROM-clause  (Russell Smith <mr-russ@pws.com.au>)
List pgsql-general
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

_________________________________________________________________
Want to block unwanted pop-ups? Download the free MSN Toolbar now!
http://toolbar.msn.co.uk/


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Creating database problem
Next
From: Thomas Hallgren
Date:
Subject: Re: Question regarding the mailing list.