[sql]Ordinare una select secondo un campo

[piero.mac]

select .... union

(select *
from tabella 
where id_carrier = '$id'
and data between '$data_start' AND $data_stop'
order by data .. o altro)
UNION
(select *
from tabella 
where id_carrier != '$id'
and data between '$data_start' AND $data_stop'
order by data .. o altro)