麻烦各位帮忙写段语句 - 编程论坛

#2

sky12165202010-05-20 09:52

帮帮忙吧各位哥哥姐姐

#3

gdy03492010-05-20 11:21

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

#4

sky12165202010-05-20 14:34

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

#5

sky12165202010-05-20 16:47

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 就开始报错了为什么呢

#6

aei1352010-05-20 21:10

少了个别名
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
这样就对了