此主题相关图片如下:eew.png

我的代码是Tables(e.form.Name & "_Table1").fill("sel ct a.客户编码, a.客户名称,a.简码,a.电话, 期初金额, sum(金额2) as 开piao金额, sum(金额1) as 收款金额,0 as 欠款 from {客户} as a left join (se lect 单位编码, 单位名称, 借方金额 as 金额1, 0 as 金额2 from {资金收付明细单} where 单据状态='已审核' union all Se lect 客户编码, 客户名称, 0, 金额 from {销售单} where 单据状态='已审核' ) As b on a.客户编码 = b.单位编码 And a.客户名称 = b.单位名称 group by a.客户编码, a.客户名称,a.简码,a.电话, 期初金额","wjhansdata",True)