I repeat. Why do you need the parentheses? Union queries don't require them.
Sorry, missed this.
They do need them if you want to use ORDER BY on the result of the 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]
