Access中的SQL 语句不会,这个SQL 语句怎么写?

[ILYYLM521125]

表一中有两个字段 GCSL(整形) KPRQ(日期)
表二中有两个字段(GCSL(整形) KPRQ(日期)
现在想根据KPRQ查出表一中和表二中各个季度的GCSL之和. 具体如下

假如 表一中数据如下
KPRQ GCSL
050103 2
050123 10
050312 12
050413 8
050523 11
050712 15
050719 4
050901 1
051013 8

表二中数据如下
KPRQ GCSL
050103 6
050223 15
050312 16
050430 5
050523 11
050712 15
050719 4
050901 1
051013 8

结果把表一二各季度之和加到一起即:
季度 数量
第一季度 61
第二季度 35
第三季度 40
第四季度 16


要求显示的行为"季度","数量",不懂Access这么费时

[wwwwb]

qb1:表一 qb2:表二
select '第一季度' as 季度,sum(zj) as 数量 from (
SELECT month, Sum(GCSL) AS zj
FROM (SELECT year([KPRQ]) AS year, month([KPRQ]) AS month, gcsl FROM qb1) AS gh
GROUP BY month union all
SELECT month, Sum(GCSL) AS zj
FROM (SELECT year([KPRQ]) AS year, month([KPRQ]) AS month, gcsl FROM qb2) AS gh
GROUP BY month) as gh where month between 1 and 3
union all
select '第二季度' as 季度,sum(zj) as 数量 from (
SELECT month, Sum(GCSL) AS zj
FROM (SELECT year([KPRQ]) AS year, month([KPRQ]) AS month, gcsl FROM qb1) AS gh
GROUP BY month union all
SELECT month, Sum(GCSL) AS zj
FROM (SELECT year([KPRQ]) AS year, month([KPRQ]) AS month, gcsl FROM qb2) AS gh
GROUP BY month) as gh where month between 4 and 6
union all
select '第三季度' as 季度,sum(zj) as 数量 from (
SELECT month, Sum(GCSL) AS zj
FROM (SELECT year([KPRQ]) AS year, month([KPRQ]) AS month, gcsl FROM qb1) AS gh
GROUP BY month union all
SELECT month, Sum(GCSL) AS zj
FROM (SELECT year([KPRQ]) AS year, month([KPRQ]) AS month, gcsl FROM qb2) AS gh
GROUP BY month) as gh where month between 7 and 9
UNION all
select '第四季度' as 季度,sum(zj) as 数量 from (
SELECT month, Sum(GCSL) AS zj
FROM (SELECT year([KPRQ]) AS year, month([KPRQ]) AS month, gcsl FROM qb1) AS gh
GROUP BY month union all
SELECT month, Sum(GCSL) AS zj
FROM (SELECT year([KPRQ]) AS year, month([KPRQ]) AS month, gcsl FROM qb2) AS gh
GROUP BY month) as gh where month between 10 and 12 ;