> except that I just added the ORDER BY clause onto each SELECT segment,
> and now I get this error:
> query failed: Incorrect usage of UNION and ORDER BY
> 
> How can I order the results while still doing the UNION ALLs?

You should only need one ORDER BY clause at the end of the whole query:

    (SELECT...)
    UNION ALL
    (SELECT...)
    UNION ALL
    (SELECT...)
    ORDER BY...

I'm not sure if this syntax is portable to other SQL-based DBMSes, though. I'm
certain that one system we use at work doesn't support it, but it's kind of a
dinosaur so I don't like to draw too many conclusions from what it doesn't 
support.

Ben

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to