Thanks Mike for the response, I didnt even think for a moment that CREATE... SELECT, INSERT ...SELECT etc. wouldnt be a subselect command (also it is a nested query).
I dont know why I didnt think about that. Mike you mentioned a very good point. Maybe I was thinking to focused to see the whole context. So to sum it all up once more nicely and clean (for the records): Nested queries: CREATE... SELECT...; INSERT... SELECT ...; REPLACE ... SELECT...; Subelects: SELECT ... SELECT...; I think that makes things clearer for me and hopefully for anybody still unsure about subselects and nested queries. Best regards Nils Valentin Tokyo/Japan 2003年 6月 25日 水曜日 23:19、Mike Hillyer さんは書きました: > 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] -- --- 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]