Aiuto query MySQL

[ras]

Ciao a tutti, ho questa query in sql:

(SELECT Id, nome, Idf_s FROM sezioni ORDER BY id) UNION
(SELECT Id, nome, Idf_s FROM gallerie ORDER BY Idf_s)

in sostanza devo riordinare il risultato di questa query usando come campo"Idf_s". E' possibile in SQL eseguire una procedura simile?

grazie!

[X3]

MySQL Reference Manual for version 4.0.21.
------------------------------------------

[14.1.7.2 UNION Syntax]

[...]

If you want to use an ORDER BY to sort the entire UNION result, you should use parentheses:

(SELECT a FROM tbl_name WHERE a=10 AND B=1 ORDER BY a LIMIT 10)
UNION
(SELECT a FROM tbl_name WHERE a=11 AND B=2 ORDER BY a LIMIT 10)
ORDER BY a;

[...]