1)
select A.cmID 代码,A.cmName 姓名,
(case when cdLengFlag=1 cdAmta else 0 end) 借入,
(case when cdLengFlag=-1 cdAmta else 0 end) 借出
from tbMaster A,tbDetail B
where A.cmID=B.cmID
2)
select A.cmID 代码,A.cmName 姓名,
sum((case when cdLengFlag=1 cdAmta else 0 end)) 总借入,
sum((case when cdLengFlag=-1 cdAmta else 0 end)) 总借出,
sum((case when cdLengFlag=1 cdAmta else -1*cdAmta end)) 余额
from tbMaster A,tbDetail B
where A.cmID=B.cmID
group by A.cmID,A.cmName
select A.cmID 代码,A.cmName 姓名,
(case when cdLengFlag=1 cdAmta else 0 end) 借入,
(case when cdLengFlag=-1 cdAmta else 0 end) 借出
from tbMaster A,tbDetail B
where A.cmID=B.cmID
2)
select A.cmID 代码,A.cmName 姓名,
sum((case when cdLengFlag=1 cdAmta else 0 end)) 总借入,
sum((case when cdLengFlag=-1 cdAmta else 0 end)) 总借出,
sum((case when cdLengFlag=1 cdAmta else -1*cdAmta end)) 余额
from tbMaster A,tbDetail B
where A.cmID=B.cmID
group by A.cmID,A.cmName
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货