select
sum(case when lcc.iCurrencyID=1 then lcc.iNumber*fUnitprice
else lcc.iNumber*lcc.fUnitprice*lcc.fExchangeRate end)
,0) as a
from lccomeslist as lcc where istatus=1
and lcc.iLCContractID in
(
select cml.iLCContractID from CmLCContract as cml
where cml.istatus=1 and cml.iLoanCustomerID = 1
)
版权归属:
Administrator
许可协议:
本文使用《署名-非商业性使用-相同方式共享 4.0 国际 (CC BY-NC-SA 4.0)》协议授权
评论区