MySQL is barely an SQL database - it doesn't support much basic SQL 89 functionality. Can any one throw some light on why professional SQL database developers want to use it for anything but simple file management? AND It is written in C as well so why do Java developers use it?
Regards, Dave > -----Original Message----- > From: Arul [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, June 25, 2002 9:05 PM > To: [EMAIL PROTECTED] > Cc: MySQL > Subject: SubQueries and Temp Tables > > > 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? > > Regards, > -Arul > > > > --------------------------------------------------------------------- > Please check > "http://www.mysql.com/Manual_chapter/manual> _toc.html" before > > posting. To request this thread, e-mail > [EMAIL PROTECTED] > > To unsubscribe, send a message to the address shown in the > List-Unsubscribe header of this message. If you cannot see it, > e-mail [EMAIL PROTECTED] instead. > --------------------------------------------------------------------- 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
