select
RY.RYXM 理财经理,
– REPLACE(KH.KHXM,SUBSTR(KH.KHXM,2,LENGTH(KH.KHXM) - 1),’****’) 客户姓名,
REPLACE(KH.KHXM,SUBSTR(KH.KHXM,2,1),’**’) 客户姓名,
CASE
WHEN (SELECT COUNT(1) FROM THTXX WHERE THTXX.KHH = KH.ID) = 1 THEN
‘是’
ELSE
‘否’
END 是否新增客户,
(SELECT XMMC FROM TXSXM WHERE TXSXM.ID = HT.XSXM) 项目名称,
HT.HTJE 合同金额
from
TKHXX KH,THTXX HT,TRYXX RY WHERE HT.KHH = KH.ID AND HT.KHJL = RY .ID AND HT.HTQDRQ > {0} AND HT.HTQDRQ < {1}
union all
select
NULL 理财经理,
NULL 客户姓名,
‘合计’ 是否新增客户,
NULL 项目名称,
sum(HTJE) 汇总
from
TKHXX KH,THTXX HT,TRYXX RY WHERE HT.KHH = KH.ID AND HT.KHJL = RY .ID AND HT.HTQDRQ > {0} AND HT.HTQDRQ < {1}