select sum(fcneze) as i,sum(fcfhfq) as h,sum(fcdqgs) as g,sum(fcshdsef) as f,sum(fcpczsfe) as e,
sum(fcfhzfzc) as d,sum(fcshzf) as c,2003 as fcdate ,'2003-8-20 18:31:44','上海','郑州' from fctj where year(fcdate)=2003 and month(fcdate)=7 and fcdhgs='苏州' and fcfhgs='上海'
sum(fcfhzfzc) as d,sum(fcshzf) as c,2003 as fcdate ,'2003-8-20 18:31:44','上海','郑州' from fctj where year(fcdate)=2003 and month(fcdate)=7 and fcdhgs='苏州' and fcfhgs='上海'
group by year(fcdate),
2003 as fcdate 这个是什么意思。
to:caiyunxia(monkey)
这个group by year(fcdate)如果这样用的话那就没有办法合计了。