But why do you need the parentheses?
This was a simplified query for example purposes.
The real query looks more like
(SELECT ...) UNION (SELECT ...) ORDER BY ...
I could rewrite this with subselects but I have found them to be slower.
My question is, why do the parentheses cause a syntax error and is this a bug?
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]