> > Sorry, missed this. > > They do need them if you want to use ORDER BY on the result > of the UNION. >
Only if you are also ordering the component parts of the union. This works create table y select * from x union select * from x order by 1 desc but this doesn't create table y select * from x order by a union select * from x order by a order by 1 desc This strikes me as a peculiar thing to want to do. Is it ANSI compliant? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]