select 车辆编号,date_format(%Y-%m) as 月份, sum(里程) as 合计里程, sum(加油费) as 合计加油费, sum(路桥杂费) as 合计路桥杂费, sum(修理费) as 合计修理费, sum(保险费) as 合计保险费 ( Select 车辆编号,出车日期,里程,加油费,路桥杂费,0 as 修理费,0 as 保险费 from 表1 union All select 车辆编号,日期,0,0,0,修理费,保险费 from 表2 ) t Group by 车辆编号,DATE_FORMAT(%Y-%m)
sum(里程) as 合计里程,
sum(加油费) as 合计加油费,
sum(路桥杂费) as 合计路桥杂费,
sum(修理费) as 合计修理费,
sum(保险费) as 合计保险费
(
Select 车辆编号,出车日期,里程,加油费,路桥杂费,0 as 修理费,0 as 保险费
from 表1
union All
select 车辆编号,日期,0,0,0,修理费,保险费
from 表2
) t
Group by 车辆编号,DATE_FORMAT(%Y-%m)
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html
http://topic.csdn.net/u/20100428/09/BC9E0908-F250-42A6-8765-B50A82FE186A.html
http://topic.csdn.net/u/20100626/09/f35a4763-4b59-49c3-8061-d48fdbc29561.html8、如何给分和结贴?
http://community.csdn.net/Help/HelpCenter.htm#结帖