56,875
社区成员




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'