这样看 select feeym,bnkname ,transtype,sum(dtransnum) dtransnum,sum(dtransmoney) dtransmoney from feedet ,bnkinfo where feeym='201006' and feedet.bnkno=bnkinfo.bnkno group by bnkname,feeym,transtype union select feeym,bnkname ,transtype,sum(dtransnum) dtransnum,sum(dtransmoney) dtransmoney from feedet ,bnkinfo where feeym='201005' and feedet.bnkno=bnkinfo.bnkno group by bnkname,feeym,transtype--或者这样 select feeym,bnkname ,transtype,sum(dtransnum) dtransnum,sum(dtransmoney) dtransmoney from feedet ,bnkinfo where feeym in('201005','201006')and feedet.bnkno=bnkinfo.bnkno group by bnkname,feeym,transtype
这样看
select feeym,bnkname ,transtype,sum(dtransnum) dtransnum,sum(dtransmoney) dtransmoney
from feedet ,bnkinfo
where feeym='201006' and feedet.bnkno=bnkinfo.bnkno
group by bnkname,feeym,transtype
union
select feeym,bnkname ,transtype,sum(dtransnum) dtransnum,sum(dtransmoney) dtransmoney
from feedet ,bnkinfo
where feeym='201005' and feedet.bnkno=bnkinfo.bnkno
group by bnkname,feeym,transtype--或者这样
select feeym,bnkname ,transtype,sum(dtransnum) dtransnum,sum(dtransmoney) dtransmoney
from feedet ,bnkinfo
where feeym in('201005','201006')and feedet.bnkno=bnkinfo.bnkno
group by bnkname,feeym,transtype
例如:
201006 广发行 101 37665 1466943.91 201005 广发行 101 18 18.88
查询语句反过来,把5月放前面6月放后面结果后面的月份也只有第一行记录是完整的,后面的记录笔数、金额也都空着,查不出来是什么问题啊