> The ANSI/ISO specs are not at all ambiguous on this. An> ORDER BY is not allowed for the SELECT statements within> a UNION. It must come at the end and applied to the resulting> UNION.
Interesting :/
Merlin