OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
RE: 4.1 and unions

From: Mike Johnson (mikesmarterliving.com)
Date: Thu Aug 04 2005 - 12:30:36 CDT

From: Scott Noyes [mailto:snoyesgmail.com]

> 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
mikesmarterliving.com (617) 886-5539

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql