感谢你的提醒,
select 生产线,
sum(case 问题类别 when "35" then 状态 else NULL end) as 缺料状态,
sum(case 问题类别 when "37" then 状态 else NULL end) as 品质状态,
sum(case 问题类别 when "38" then 状态 else NULL end) as 帮助状态,
sum(case 问题类别 when "36" then 状态 else NULL end) as 维修状态
from 产线状态表
group by 生产线
这样写
似乎就是我要的结果
|