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