Re: novice question about NOTICE:...

Not an expert by any means, but I think you need to include the tierdat
table in the from clause like this:

select oid, lang from cgidat, tierdat where cgidat.state = 'testing' and
cgidat.lang = tiredat.lang and tierdat.tier = '0' order by lang;

Kent

-----Original Message-----
From: pgsql-novice-owner@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org]On Behalf Of Lloyd Vancil
Sent: Wednesday, April 03, 2002 3:37 PM
To: pgsql-novice@postgresql.org
Subject: [NOVICE] novice question about NOTICE:...


    Tried to search the novice archives and the engine just never
returns an answer.  This is probably a pretty common question so I
hope I'll get a quick answer.


   I have two tables  cgidat and tierdat.
    I want to select all occurrences of data in cgidat where
cgidat.state = testing and cgidat.lang = tierdat.lang and
tierdat.tier = 0

   so I did


    select oid, lang from cgidat where cgidat.state = 'testing' and
cgidat.lang = tiredat.lang and tierdat.tier = '0' order by lang;

I get the expected results but I also get
Adding missing FROM-clause entry for table "tierdat"


   Huh?

    Thanks
    Lloyd

--

                 lev@apple.com

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org