Hi James, I don' t understand your question. Why do you hink you that the brackets would't work ?
I tried that without any problems. Please post your code. Here is mine: SELECT * FROM sensei WHERE last_name IN (SELECT last_name FROM sensei UNION ALL select last_name FROM sensei) ORDER BY e_mail; Best regards Nils Valentin Tokyo/Japan 2003年 8月 14日 木曜日 17:04、James Fryer さんは書きました: > Assuming a legal SELECT statement, this works fine: > > CREATE TABLE Foo SELECT ... > > but this does not: > > CREATE TABLE Foo (SELECT ...) > > This is a problem for me as I'd like to use the output of a > SELECT...UNION...ORDER BY statement as input to CREATE TABLE. > > Same holds for INSERT INTO. > > Is this a bug? I can't find it documented anywhere. > > Jim > -- > James Fryer / [EMAIL PROTECTED] / [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]