Tables(e.Form.Name & "_Table1").Fill("select *,合同量 - 发货量 + 退货量 as 欠交量 from (Select Distinct a.执行状态,a.合同类型,a.简称 As 客户,a.合同主号,a.合同,a.日期,a.内定交货日,a.名称,a.牌号,a.规格_厚度 As 厚度,a.规格_宽度 As 宽度,a.规格_长度 As 长度,a.单价,a.硬度_状态 As Hv状态,a.硬度_MIN As HvMin,a.硬度_MAX As HvMax,a.单位,a.数量 As 合同量, (select sum(数量) f rom {工序合并表} as b where a.合同 = b.合同 And b.表名 = '销售及加工出库') as 发货量 ,(select sum(数量) from {工序合并表} as b where a.合同 = b.合同 And b.工序 = '退货入库') as 退货量 F rom {销售及加工合同} As a) as a Where " & flt & " ORDER BY a.执行状态,a.合同类型,a.简称,a.合同主号,a.合同","ShcsErpSql",True)
加好友 
发短信
Post By：2018/6/11 22:01:00 [显示全部帖子]
