SELECT

h1.项目 AS 项目,

h1.送货总额 - COALESCE(h1.退货总额, 0) + COALESCE(h1.调差总额, 0) AS 项目送货总额,

h1.实收金额,

h1.送货总额 - COALESCE(h1.退货总额, 0) + COALESCE(h1.调差总额, 0) - h1.实收金额 AS 项目应收金额

FROM (

SELECT

(SELECT SUM(b1.FALLAMOUNT)

FROM T_SAL_DELIVERYNOTICEENTRY_F b1

LEFT JOIN T_SAL_DELIVERYNOTICE b2 ON b1.FID = b2.FID

WHERE b2.FBILLTYPEID = '6402dee86eae0c' AND (b2.FCUSTOMERID = (SELECT FMASTERID FROM T_BD_CUSTOMER WHERE FNUMBER = '#FCUSTOMERID#') OR '#FCUSTOMERID#' = '')) AS 送货总额,

(SELECT SUM(b1.FALLAMOUNT)

FROM T_SAL_DELIVERYNOTICEENTRY_F b1

LEFT JOIN T_SAL_DELIVERYNOTICE b2 ON b1.FID = b2.FID

WHERE b2.FBILLTYPEID = '6417ccce20dcf2' AND (b2.FCUSTOMERID = (SELECT FMASTERID FROM T_BD_CUSTOMER WHERE FNUMBER = '#FCUSTOMERID#') OR '#FCUSTOMERID#' = '')) AS 退货总额,

(SELECT FNAME FROM T_BD_CUSTOMER_L b1

LEFT JOIN T_BD_CUSTOMER b2 on b1.FCUSTID=b2.FCUSTID

WHERE b2.FNUMBER = '#FCUSTOMERID#') AS 项目,

(SELECT

SUM(

CASE

WHEN b2.F_KDUP_COMBO2 = 1 THEN b1.FALLAMOUNT

WHEN b2.F_KDUP_COMBO2 = 2 THEN -b1.FALLAMOUNT

ELSE 0

END

) AS 调差总额

FROM

T_SAL_DELIVERYNOTICEENTRY_F b1

LEFT JOIN T_SAL_DELIVERYNOTICE b2 ON b1.FID = b2.FID

WHERE

b2.FBILLTYPEID = '64b6077865bee7'

AND (b2.FCUSTOMERID = (SELECT FMASTERID FROM T_BD_CUSTOMER WHERE FNUMBER = '#FCUSTOMERID#') OR '#FCUSTOMERID#' = '')) AS 调差总额,

(SELECT COALESCE(SUM(b1.FREALRECAMOUNTFOR), 0)

FROM T_AR_RECEIVEBILL b1

WHERE (b1.FCUSTID = (SELECT FMASTERID FROM T_BD_CUSTOMER WHERE FNUMBER = '#FCUSTOMERID#') OR '#FCUSTOMERID#' = '')) AS 实收金额

) AS h1;

现在模糊查询出来的数据全部加在一起了麻烦各位大神帮忙看看

产品问题SQL直接账表中 如何模糊搜索全部后按照客户分组

50 产品问题 SQL直接账表中 如何模糊搜索全部后按照客户分组

恭喜您！

产品问题
SQL直接账表中如何模糊搜索全部后按照客户分组

50 产品问题 SQL直接账表中如何模糊搜索全部后按照客户分组