已解决，substr(p4,0,7) 那儿多了个双引号

把这个删了试试

子查询里不能排序

看着像是日期的问题，可以先排除一下 ${if(len(p4) == 0,"","and ckrq < " + substr(p4,0,7) + "")} 这语句，${if(len(p4) == 0,"","and ckrq = ‘" + substr(p4,0,7) + "'")}

或者

SELECT ddkh, sum(hz - sjsk) AS syhk

  FROM (SELECT (SELECT name

                  FROM bd_customer@ncc0614

                 WHERE pk_customer = a.ccustomerid) AS ddkh, --订单客户

               substr(b.dbizdate, 0, 7) AS ckrq, --入库日期

               sum(b.norigtaxmny) AS hz, --货值

               CASE

                 WHEN sum(c.money_cr) IS NULL THEN

                  0

                 ELSE

                  sum(c.money_cr)

               END AS sjsk --实际收款

          FROM ic_saleout_h@ncc0614 a

          LEFT JOIN ic_saleout_b@ncc0614 b

            ON a.cgeneralhid = b.cgeneralhid

          LEFT JOIN so_custaccountdetail@ncc0614 c

            ON b.cgeneralbid = c.cgeneralbid

         WHERE a.dr = 0

           AND b.dr = 0

           AND c.dr = 0

         GROUP BY a.ccustomerid, substr(b.dbizdate, 0, 7)

         ORDER BY substr(b.dbizdate, 0, 7))

 WHERE 1=1

   and ddkh = "马鞍山市玲俊贸易有限公司"

   and ckrq < "2023-09-01"

 GROUP BY ddkh

这样应该就能定位到具体问题点，希望能帮助到你