ORDERing two UNION queries: Non-Subquery UNION Execution

[ioannes <ioannes@xxxxxxxxxxxxxx>]

http://dev.mysql.com/doc/internals/en/select-union.html

Does anyone know what this means?  Can it be implemented in the flow of 
php code without explicitly creating temp tables in the database?

My query is like:

$query = "
       (SELECT
       Table.field, [other fields]
       FROM Table [other JOINs]
       ORDER BY Table.field
       )
       UNION
       (SELECT
       Table2.field, [other fields]
       FROM Table2 [other JOINs]
       ORDER BY Table2.field
       )
       ";

and I want the ORDER to apply to the whole UNIONed result.

John

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