56,687
社区成员
发帖
与我相关
我的任务
分享
SELECT '一月收入',a.*
FROM a
WHERE SUBSTRING(DATE,6,2)='01'
UNION ALL
SELECT '合计','',SUM(num)
FROM a
WHERE SUBSTRING(DATE,6,2)='01'
UNION ALL
SELECT '一月支出',b.*
FROM b
WHERE SUBSTRING(DATE,6,2)='01'
UNION ALL
SELECT '合计','',SUM(num)
FROM b
WHERE SUBSTRING(DATE,6,2)='01'
UNION ALL
SELECT '二月支出',A.*
FROM A
WHERE SUBSTRING(DATE,6,2)='02'
UNION ALL
SELECT '合计','',SUM(num)
FROM a
WHERE SUBSTRING(DATE,6,2)='02'
UNION ALL
SELECT '二月支出',b.*
FROM b
WHERE SUBSTRING(DATE,6,2)='02'
UNION ALL
SELECT '合计','',SUM(num)
FROM b
WHERE SUBSTRING(DATE,6,2)='02'