Hi Egor, Thank you for the reply. Do you mind to go abit mor into details ? It seems that I got domething wrong here.
If nested queries are not only subselects, which other nested queries exist there ? Do you mind just writing a few samples, please ? Sorry if this seems a simple question - from the manual I misunderstood that nested queries and subselects are the same, which is obviously not the case as I heard now. I understood that Subselects originally exist of 2 or more SELECT... statements. Best regards Nils Valentin Tokyo/Japan 2003年 6月 25日 水曜日 19:53、Egor Egorov さんは書きました: > "Nils Valentin" <[EMAIL PROTECTED]> wrote: > > I have a question regarding the MySQL feaures. > > > > From Version 4.1 Full subselect support was/is announced. > > > > However if I understood correctly then already from Version3.23-41 (or > > earlier) there are some subselect functions already included. For xample > > if I try this: > > > > CREATE TABLE tblname_new SELECT * FROM tblname_ori; > > > > then it works. Or do I have a misunderstanding of subselects (nested > > queries) ?? > > Nested queries is not only subselects. Yes, you are right, some nested > queries like INSERT .. SELECT, CREATE .. SELECT was implemented in earlier > than 4.1 > > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Egor Egorov > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > <___/ www.mysql.com -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]