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
_________________________________________________________________
Want to block unwanted pop-ups? Download the free MSN Toolbar now! http://toolbar.msn.co.uk/
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
