一个关于查询的问题

SELECT *
FROM [SELECT 半成品入库.日期, 半成品入库.摘要, 半成品入库.部门, 半成品入库.凭单号, 半成品入库.生产单号, 半成品入库.货品编号, 半成品入库.颜色, 半成品入库.材质, 半成品入库.[单重(G)], 半成品入库.位置, 半成品入库.[入库数量(PCS)], 半成品入库.[入库重量(KG)], NULL as [出库数量(PCS)], NULL as [出库重量(KG)], NULL AS [结存数量(PCS)], NULL AS [结存重量(KG)], 半成品入库.备注, [货品编号]&[颜色]&[材质] as 货品编号颜色材质, 半成品入库.出入代码  FROM 半成品入库 UNION ALL SELECT 半成品出库.日期, 半成品出库.摘要, 半成品出库.部门, 半成品出库.凭单号, 半成品出库.生产单号, 半成品出库.货品编号, 半成品出库.颜色, 半成品出库.材质, 半成品出库.[单重(G)], 半成品出库.位置, NULL as [入库数量(PCS)], null as [入库重量(KG)], 半成品出库.[出库数量(PCS)], 半成品出库.[出库重量(KG)], NULL AS [结存数量(PCS)], NULL AS [结存重量(KG)], 半成品出库.备注, [货品编号]&[颜色]&[材质] as 货品编号颜色材质, 半成品出库.出入代码  FROM 半成品出库 ORDER BY 货品编号颜色材质, 货品编号, 颜色, 材质, 日期, 出入代码]. AS [%$##@_Alias];