sql case when 老是语法报错,请问语法哪错了?SELECT zhu.mingzi,zhu.riqi,zhu.liucheng,zhu.xinghao,zhu.shuliang,casewhen [liucheng] = '点装' then '1'when [liucheng] = '装脚' then '2'when [liucheng] = '只装' then '3'when [liucheng] = '点胶' then '4'when [liucheng] = '切腿' then '5'when [liucheng] = '电测' then '6'when [liucheng] = '全检' then '7'else '8' end AS dj[shuliang]*[danjia] AS zongjiaFROM danjia,zhu;

sql case when 老是语法报错,请问语法哪错了?
SELECT zhu.mingzi,zhu.riqi,zhu.liucheng,zhu.xinghao,zhu.shuliang,
case
when [liucheng] = '点装' then '1'
when [liucheng] = '装脚' then '2'
when [liucheng] = '只装' then '3'
when [liucheng] = '点胶' then '4'
when [liucheng] = '切腿' then '5'
when [liucheng] = '电测' then '6'
when [liucheng] = '全检' then '7'
else '8' end AS dj
[shuliang]*[danjia] AS zongjia
FROM danjia,zhu;