Nissim Lugasy writes:
> Are there plans for mysql to have the capabilities to execute single sql
> statement with nested SELECT . or Is there a way around this for the time
> being?
>
> Thanks
>
Hi!
For the moment, you can only do (with MySQL 4.0) UNION's in all
variants with as many SELECT's as you wish.
Derived tables should come in 4.1 or may be even before.
Nested selects are scheduled for one of 4.1 releases.
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
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
