Re: New UNION ALL and problem with ORDER BY ?

2003-03-20 Thread Fred van Engen
Hi, On Wed, Mar 19, 2003 at 03:11:38PM -0800, Mike Lemke wrote: Hello MySQL Guru's- This is regarding UNION support in MySQL 4.0.12. Never used it, but ... The query below is attempting to return rows that can be easily parsed for the purposes of creating XML. The ORDER BY is not being

New UNION ALL and problem with ORDER BY ?

2003-03-19 Thread Mike Lemke
Hello MySQL Guru's- This is regarding UNION support in MySQL 4.0.12. The query below is attempting to return rows that can be easily parsed for the purposes of creating XML. The ORDER BY is not being processed properly at the end of the query. Sample scripts are shown below, to setup the DB and