I am not sure that could be viewed as a subselect, as it in not a SELECT within an SELECT, but is instead a SELECT within a CREATE. I would imagine that the SELECT within the CREATE is easier to implement that the actual SELECT within a SELECT.
Regards, Mike Hillyer www.vbmysql.com > -----Original Message----- > From: Nils Valentin [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 25, 2003 1:12 AM > To: [EMAIL PROTECTED] > Subject: Subselect functionality > > > Hi MySQL Fans ;-), > > 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) > ?? > > Best regards > -- > --- > 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/mysql?> [EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]