| SELECT t.Goods_No,t.Customer_na,t.Goods_name,t.year,t.brand,t.sex,t.season,t.color,t.Size_class,t.size,t.Customer_id,t.WholeSalePrice,t.UnitPrice,sum(t.quantity) quantity FROM (select c.Customer_na,dig.Goods_No,g.Goods_name,g.year,g.brand,g.sex,g.season,dc.color,g.Size_class,ds.size,c.Customer_id,g.WholeSalePrice,g.UnitPrice, Case when ds.FieldName='S1' then ded.S1 when ds.FieldName='S2' then ded.S2 when ds.FieldName='S3' then ded.S3 when ds.FieldName='S4' then ded.S4 when ds.FieldName='S5' then ded.S5 when ds.FieldName='S6' then ded.S6 when ds.FieldName='S7' then ded.S7 else 0 end as quantity from DELIVERY di left join DELIVERYGoods dig on di.deliveryid=dig.deliveryid left join Goods g on dig.Goods_No=g.Goods_no left join DELIVERYDetail ded on dig.DELIVERYgoodsid=ded.DELIVERYgoodsid left join Customer c on di.Customer_Id=c.Customer_id left join DictSize ds on g.Size_class=ds.Size_Class left join DictColor dc on ded.ColorId=dc.ColorID where g.brand ='${品牌}' and g.year = '${年份}'and g.season = '${季节}' ) t GROUP BY t.year,t.Customer_na,t.goods_name,t.Goods_No,t.brand,t.sex,t.season,t.color,t.Size_class ,t.size,t.Customer_id,t.WholeSalePrice,t.UnitPrice HAVING sum(t.quantity)<>0 想把参数变为多选可以用，现在这个参数只能单选 |
