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

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