Take a look at: http://www.mysql.com/doc/T/O/TODO.html and http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html
You can do what you want to do easily by using an API (PHP, Perl, etc.) Is it possible for you to use an external program, or does it have to be SQL only? Gurhan ----- Original Message ----- From: "Darley, Terry" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 20, 2002 10:29 AM Subject: Sub-selects > To Whom It May Concern: > > I've just joined the mailing list for problem sharing/helping and the first > 2 e-mails I received, demonstrates a need for sub-selects in MySQL. Is there > any plan to write this into future releases of MySQL ? If so, when do you > anticipate this will be released ? > > In the absence of sub-selects how would you solve the problem below ? > > DELETE FROM order_details > WHERE order_number NOT IN > (SELECT order_number FROM order_header); > > ... remove all order details where there isn't a record in the order header > ! > > Much obliged in anticipation. > > Regards, > > Terry > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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
