The simple answer would be that the syntax says:
http://www.mysql.com/doc/en/UNION.html
SELECT... UNION... SELECT...
Further down the page it says
If you want to use an ORDER BY for the total UNION result, you should use parentheses:
(SELECT a FROM table_name WHERE a=10 AND B=1 ORDER BY a LIMIT 10) UNION (SELECT a FROM table_name WHERE a=11 AND B=2 ORDER BY a LIMIT 10) ORDER BY a;
which is what I am doing.
The problem seems to be with the syntax of CREATE TABLE and INSERT INTO, not the syntax of UNION.
Jim -- James Fryer / [EMAIL PROTECTED] / [EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]