[EMAIL PROTECTED] ("C G") writes:
> 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
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
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 29 October 2004 08: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;
^
Your join doesn't alias anything
