From: Scott Noyes [mailto:[EMAIL PROTECTED]
> UNION is not broken; the syntax in the given comment is > incorrect. You can do > SELECT * FROM table UNION SELECT * FROM table > or > (SELECT * FROM table) UNION (SELECT * FROM table) > but not > SELECT * FROM table UNION (SELECT * FROM table) Oh, interesting. My next question was going to be if the second syntax is correct (all subqueries enclosed in parens), but looks like it's good. Thanks, Scott. -- Mike Johnson Smarter Living, Inc. Web Developer www.smartertravel.com [EMAIL PROTECTED] (617) 886-5539 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]