-----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----- ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend