前几天遇到一个难题，对两个数据表中的数据进行数据统计，要求：同年，同月，同人，同车的数据自动进行统计，并通过OWC将对应的信息进行
USE TQNPOA
GO
/**//*成功语句*/
select Cdriver as 司机,Ctype as 车型,Cnumber as 车号,sum(cfutel) as 月耗油量,
datename(year, Stimte) as 年, datename(month, stimte) as 月
from ViewDriverUOil
group by
datename(year, Stimte),datename(month, stimte),Ctype,Cdriver,
Cnumber order by
datename(year, stimte) asc
select Ctype as 车型,Cmonth as 月份,COiluse as 耗油量
from Car_oil_info
USE TQNPOAGO/**//*成功语句*/select Cdriver as 司机,Ctype as 车型,Cnumber as 车号,sum(cfutel) as 月耗油量, datename(year, Stimte) as 年, datename(month, stimte) as 月from ViewDriverUOil group bydatename(year, Stimte),datename(month, stimte),Ctype,Cdriver,Cnumber order bydatename(year, stimte) ascselect Ctype as 车型,Cmonth as 月份,COiluse as 耗油量from Car_oil_info