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(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org]On Behalf Of Lloyd Vancil
Sent: Wednesday, April 03, 2002 3:37 PM
To: pgsql-novice(at)postgresql(dot)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(at)apple(dot)com

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