Order by

Hi all,

Is anyone know that if we allow order-by clause in the view structure.
If not, how can we take the ordering of the UNION ALL in 2 different bags ?

Thanks!!

MICHAEL