Z4u3z1 回复 yaaa(提问者)SELECT A.类别名称,B.产品名称,SUM(C.数量) [总数] FROM 产品类别 A
INNER JOIN 产品 B ON A.类别ID=B.类别ID
INNER JOIN 订单明细 C ON B.产品ID=C.产品ID
WHERE 1=1 ${IF(LEN(cplb)==0,\"\",\" AND A.类别ID in(\'\"+cplb+\"\')\")}
${IF(LEN(cpmc)==0,\"\",\" AND b.产品ID in(\'\"+cpmc+\"\')\")}
group by A.类别名称,B.产品名称