Re: What's it: NOTICE: Adding missing FROM-clause entry - Mailing list pgsql-general

> 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