如图：上面的是A表，下面的是B表，现在想将两张表里的ysje，sshje，je，she，ml，chbje，ticheng 全部汇总了，要求是日期相同的按日期汇总，日期不同的单独罗列出来。注:有可能A表里有的日期B表没有，也有可能B表里有的日期A表没有。麻烦各位大哥帮帮忙些出语句 感激不尽

帮帮忙吧各位哥哥姐姐

select rq ,sum(ysje),sum(je),sum(she),sum(ml),sum(chbje),sum(ticheng) from(
select rq,ysje，sshje，je，she，ml，chbje，ticheng  from a
union all
select rq,ysje，sshje，je，she，ml，chbje，ticheng from b)
group by rq

咋说呢 太感谢了 版主太敞亮了

select rq ,sum(ysje),sum(je),sum(she),sum(ml),sum(chbje),sum(ticheng) from(
select rq,ysje，sshje，je，she，ml，chbje，ticheng  from a
union all
select rq,ysje，sshje，je，she，ml，chbje，ticheng from b)
group by rq

这段语句不行 提示group by rq附近有语法错误 标点符号我也给改过来了  但是还是不行 单独执行
select rq,ysje，sshje，je，she，ml，chbje，ticheng  from a
union all
select rq,ysje，sshje，je，she，ml，chbje，ticheng from b
就可以 带上select rq ,sum(ysje),sum(je),sum(she),sum(ml),sum(chbje),sum(ticheng) from 就开始报错了 为什么呢

少了个别名
select rq ,sum(ysje),sum(je),sum(she),sum(ml),sum(chbje),sum(ticheng) from(
select rq,ysje，sshje，je，she，ml，chbje，ticheng  from a
union all
select rq,ysje，sshje，je，she，ml，chbje，ticheng from b) xtable
group by rq
这样就对了