<p>select T.* from (select 到货日期 as [到/送货日期], 入库单号 as [入库单号/货单号], 合同号, 供应商名 as [供应商名/客户名], 客户料单号, 货物编码, 货物名称, 规格型号, 单位, [数量(PC)] as [入库数量(PC)], [单价(¥/PC)] as [入库单价(¥/PC)], [金额(¥)] as [入库金额(¥)], 0 as [出库数量(PC)], 0 as [出库单价(¥/PC)], 0 as [出库金额(¥)] from [入库明细$] union all<br/>select 送货日期, 货单号, 合同号, 客户名, 客户料单号, 货物编码, 货物名称, 规格型号, 单位, 0 as [入库数量(PC)], 0 as [入库单价(¥/PC)], 0 as [入库金额(¥)], [数量(PC)] as [出库数量(PC)], [单价(¥/PC)] as [出库单价(¥/PC)], [金额(¥)] as [出库金额(¥)] from [出库明细$]) T order by T.[到/送货日期] T.[入库数量(PC)] DESC</p> |