Re: adding missing FROM-clause

On Sat, 30 Oct 2004 01:42 am, C G wrote:
> 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;
> 
Instead 
SELECT c1 FROM t2, t1 INNER JOIN t2 ON t2.c2 = t1.c2 WHERE t3.c3=t2.c3

OR

SELECT c1 FROM t1 INNER JOIN t2 ON t2.c2 = t1.c2 JOIN t3 ON 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
> 
>