Обсуждение: adding missing FROM-clause

Поиск
Список
Период
Сортировка

adding missing FROM-clause

От
"Colin Gillespie"
Дата:
Dear All,

I have a simple join query

SELECT c1 FROM t1
INNER JOIN
t2 ON t2.c2 = t1.c2 WHERE t3.c3= t2.c3;

Which gives the expected result but I get the message
NOTICE:  adding missing FROM-clause entry for table "t3"

How do I get rid of this NOTICE, i.e. how should I construct my select query.

Many thanks

Colin