Skip site navigation (1) Skip section navigation (2)

Re: adding missing FROM-clause

From: "Uwe C(dot) Schroeder" <uwe(at)oss4u(dot)com>
To: "C G" <csgcsg39(at)hotmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: adding missing FROM-clause
Date: 2004-10-30 00:37:23
Message-ID: 200410291737.23908.uwe@oss4u.com (view raw or flat)
Thread:
Lists: pgsql-general
-----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 as t3
I'd say you get rid of the notice once you replace t3 with t1

>
> 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

- -- 
	UC

- --
Open Source Solutions 4U, LLC	2570 Fleetwood Drive
Phone:  +1 650 872 2425		San Bruno, CA 94066
Cell:   +1 650 302 2405		United States
Fax:    +1 650 872 2417
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQFBguJDjqGXBvRToM4RArh0AJ46apSm5O/dX4QYJxuC44yyjYcWHQCfZpMu
+UU1SoXolAFx7fEhMUUXp5w=
=GRUr
-----END PGP SIGNATURE-----


In response to

pgsql-general by date

Next:From: Tom LaneDate: 2004-10-30 01:59:17
Subject: Re: 8.0 Beta 4 denying network connections?
Previous:From: Vinko VrsalovicDate: 2004-10-30 00:07:07
Subject: 8.0 Beta 4 denying network connections?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group