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;