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/