What's it: NOTICE: Adding missing FROM-clause entry

Hi All! :)
There are two tables:
test(a int4,b varchar(20));
test2(c int4,d varchar(20));
I do the following:
select a,b,test2.d from test where a=test2.c;

Try this:

select a,b,test2.d from test test2 where a=test2.c;

You are creating a 'test' reference and a 'test2' reference, which I
doubt is what you wanted.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Vitaliy V. Romanets writes:

I do the following:
select a,b,test2.d from test where a=test2.c;
and i receive:
NOTICE: Adding missing FROM-clause entry for table "test2"

The query should be

select a,b,test2.d from test, test2 where a=test2.c;

--
Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter