S el ect distinct x.科目编码 As 会计科目_编码,y.科目名称 As 会计科目_科目名称,借方金额 As 金额_借方金额,贷方金额 As 金额_贷方金额,借方数量 As 数量_借方数量,贷方数量 As 数量_贷方数量,借方原币金额 As 原币金额_借方,贷方原币金额 As 原币金额_贷方 from ( Se lect left(P01.科目编码,3) As 科目编码, Sum(P01.借方本币金额) As 借方金额, Sum(P01.贷方本币金额) As 贷方金额, sum( iif(借方本币金额<>0 , 数量 , 0)) As 借方数量, sum( iif(贷方本币金额<>0 , 数量 , 0 )) As 贷方数量,sum( iif(借方本币金额<>0 , 原币金额 , 0 )) As 借方原币金额,sum( iif(贷方本币金额<>0 , 原币金额 , 0 )) As 贷方原币金额 FROM P01 WHERE P01.账套编码='HYXJTJ-JBJS-001' And P01.年=2019 And P01.月=1 AND P01.凭证编号 Between 1 And 17 GROUP BY left(P01.科目编码,3) ) x left join (Sel ect K01.科目编码, k01.科目名称 FROM {K01} WHERE Len(科目编码)<=3 and 年度=2019 And 账套编码='HYXJTJ-JBJS-001') y on x.科目编码 = y.科目编码 order by x.科目编码
---------------------------
确定
---------------------------
数据库 Access 在Foxtable的执行Sql语名中不报错,但是在程序中会标题所示错误!
加好友 
发短信
Post By：2020/3/10 19:42:00 [只看该作者]
