本文介绍了我想要一年的明智数据的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有两张桌子像 1张表
i have two table like 1 table
Date DistId BranchID CreditAmount 01/01/2016 101 1 5000 02/01/2016 101 1 5000 01/02/2016 101 1 6000 01/01/2016 101 2 700 01/01/2016 102 1 4002 table
2 table
Date DistId BranchId DebitAmount 01/01/2016 101 1 6000 02/01/2016 101 1 7000 01/02/2016 101 1 9000 01/01/2016 101 2 500 01/01/2016 102 1 400i希望如下所示
i want to like as under below
Date DistId BranchId CreditAmount DebitAmount Balance AmountType 01/01/2016 101 1 10000 13000 3000 Dr 01/02/2016 101 1 16000 22000 6000 Dr1 / 12/2016 我的尝试:
as 1/12/2016 What I have tried:
select a.Date, a.DistID, a.BranchId, sum(CreditAmount) from t a;推荐答案
SELECT a.Date, a.DistID, a.BranchId, SUM(a.CreditAmount) AS CreditAmount, NULL AS DebitAmount FROM a GROUP BY a.Date, a.DistID, a.BranchId UNION SELECT b.Date, b.DistID, b.BranchId, NULL, SUM(b.DebitAmount) FROM b GROUP BY b.Date, b.DistID, b.BranchId
更多推荐
我想要一年的明智数据
发布评论