两个查询结果能否合并(union)后再sum,group by?

[安优小青和他的程序生活]

源:
(SELECT jjk,sum(jn1) as a1 from b_jj where jcyear='2004' and jcmonth='12' group by jjk ) union
(SELECT hjk,sum(hn1) as a1 from b_hc where hcyear='2004' and hcmonth='12' group by hjk)

目的:

select aa.jjk,sum(a1) from (源) as aa group by aa.jjk

我在access2000里试验,提示join 语句出错.

各位,通过一条sql语句实现有什么办法?

[lipkissnow]

當然是可以的了。你把join后的表作爲一個表就行了。

[安优小青和他的程序生活]

楼上的我用union不是join

[631799]

access的子查询不支持union的用法吧?