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 processed properly at the
> end of the query.  Sample scripts are shown below, to
> setup the DB and test the query.
> 

...

Did you try it with braces as explained in the UNION documentation?

http://www.mysql.com/doc/en/UNION.html


Your query would then be:


(SELECT  1 AS Tag, 
        NULL AS Parent,
        Users.UserId    AS 'User!1!UserID!hide',
        Users.FirstName AS 'User!1!FirstName',
        Users.LastName  AS 'User!1!LastName',
        NULL                    AS 'Cars!2!CarID!hide',
        NULL                    AS 'Cars!2!Details',
        NULL                    AS 'Trips!3!TripID!hide',
        NULL                    AS 'Trips!3!Mileage'
FROM Users 
WHERE Users.UserId='2')

UNION ALL

(SELECT  2, 
        1,
        Users.UserId,
        NULL,
        NULL,
        Cars.CarID,
        Cars.Details,
        NULL,
        NULL
FROM Cars
INNER JOIN Users ON Cars.UserID = Users.UserID 
WHERE Users.UserId='2')

UNION ALL

(SELECT  3, 
        2,
        Users.UserId,
        NULL,
        NULL,
        Cars.CarID,
        NULL,
        Trips.TripID,
        Trips.Mileage
FROM Trips
INNER JOIN Cars ON Trips.CarID = Cars.CarID 
INNER JOIN Users ON Cars.UserID = Users.UserID 
WHERE Users.UserId='2')

ORDER BY 'Cars!2!CarID!hide', 
         'User!1!UserID!hide',
         Tag
;


Regards,

Fred.

-- 
Fred van Engen                              XB Networks B.V.
email: [EMAIL PROTECTED]                Televisieweg 2
tel: +31 36 5462400                         1322 AC  Almere
fax: +31 36 5462424                         The Netherlands

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to