Agreed Ralf... Not all SubQueries can be replaced by Joins.. Thats why we have planned for Temp Tables.. Any ideas on it..
----- Original Message ----- From: "Ralf Narozny" <[EMAIL PROTECTED]> To: "Arul" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]> Sent: Wednesday, June 26, 2002 3:00 PM Subject: Re: SubQueries and Temp Tables > Hiho hiho! > > Which joins could that be? I think most if not all subqueries should be > replacable with joins. > > Greetings > Ralf > > Arul wrote: > > >Hi All > > > > I am currently porting our application from Oracle to MySQL. > >We have some subqueries in oracle which cannot be ported into MySQL.We even > >tried some joins which didnt work out.. > > > > So Could anyone throw some light on Temporary tables.Is this the right way > > to do it.. > > > > Since our main query is dependent on the inner query we thought we could > >run > > the inner queryfirst and create a temp table.Then we could have a join > > between the main table and the inner table. > > > > Is this advisable.. > > > > Any other better options? > > > > > > > > -- > Ralf Narozny > Splendid Internet GmbH > Skandinaviendamm 212, 24109 Kiel, Germany > fon: +49 431 660 97 0, fax: +49 431 660 97 20 > mailto:[EMAIL PROTECTED], http://www.splendid.de > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php