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

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(at)gmx(dot)net http://funkturm.homeip.net/~peter