SQL: UNION ALL and ORDER BY

I have an SQL QUERY containing a number of SELECT FROM WHERE's joined by UNION ALL statements. Following the last statement is a single ORDER BY clause.

On my system the ORDER BY affects the order of all the results from the preceding SELECTs.

As I may wish to port this to other databases, is the feature described above standard SQL or specific to my implementation? Received on Tue Jul 10 2001 - 23:46:14 CEST