摘要： SELECT sum(a.buycount) buycount,(SELECT c.name from tb_product_type_info c -- 按年WHERE c.id=b.typeid) typename,year(a.createdate)as year from tb_order_detail a,tb_product_pk b where a.productname=b.oldproduct GROUP BY b.typeid,year(a.createdate);SELECT sum(a.buycount) buycount,(SELECT c.name from tb_ 阅读全文