110,537
社区成员
发帖
与我相关
我的任务
分享
SELECT
a.*
,B.N_JG,DBO.[F_GetZNJByDateAndJE](d_ZhiNaJQS,N_YongShuiF) ZNJ,N_JE+DBO.[F_GetZNJByDateAndJE](d_ZhiNaJQS,N_YongShuiF) N_ZJE,
case c.S_ChuLiJG when '0' then '成功交易' when '1' then '金额不足已销户或无此帐户' when '2' then '帐号不存在'
when '3' then '帐号冻结' when '4' then '通讯超时' when '5' then '体统忙' when '6' then '帐号已挂失'
when '8' then '非结算帐户' when '12' then '需要更换存折' when '23' then '帐号不正确' when '99' then '其他原因' else '' end S_KouKuanQK
FROM
[dbo].[ZW_YingYeZ] A
inner join (select sum(n_JG*N_XiShu) N_JG,I_FEEID from zw_yingyez_zb group by I_FEEID) B on a.I_FEEID=B.I_FEEID
left join
(select I_FEEID,S_ChuLiJG from YW_FaSongSJ_MX a inner join (
select MAX(id) id from YW_FaSongSJ_MX group by I_FEEID) b on a.ID=b.id)c on a.i_feeid=c.i_feeid
WHERE
I_XiaoZhang in(0,-1) AND I_JLZT = 0 AND N_KaiZhangJE > 0 AND S_CID = '101012440'