联合查询后排序怎样实现？

各位大侠：

做了一个联合查询，最后想对联合查询的结果进行排序，不知道怎么实现？请大家赐教！

SELECT 周次 as 周, AHPRTN AS 部番, AHRSTK AS 在库数, AHRWTS AS 在途数 ,0 as 订单,0 as 需求 from 在库查询;
UNION ALL select 周次 as 周, APPRTN AS 部番, 0 AS 在库数, 0 AS 在途数, 订单数 as 订单 ,0 as 需求 from 订单明细;
UNION ALL select  周次 as 周,輸出型番 AS 部番, 0 as 在库数, 0 as 在途数, 0 as 订单, 需求量 as 需求 from 周次需求;

查询的结果进行周、部番的排序应该怎样改？

谢谢！