一个 语句的写法问题

[chang1216]

在存储过程里下面的语句怎么修改
case
WHEN bm_yuangong.Person_zhuangtai = 0 THEN '离职'
end as Person_zhuangtai1,
case
WHEN bm_yuangong.Person_zhuangtai = 1 THEN '试用在职'
end as Person_zhuangtai1,
case
WHEN bm_yuangong.Person_zhuangtai = 2 THEN '正式在职'
end as Person_zhuangtai1
就应该显示一个状态 zhuangtai1 没这么写过 请帮忙

[ping3000]

select Person_zhuangtai1 = ( case WHEN bm_yuangong.Person_zhuangtai = 0 THEN '离职'
WHEN bm_yuangong.Person_zhuangtai = 1 THEN '试用在职'
WHEN bm_yuangong.Person_zhuangtai = 2 THEN '正式在职'
else '' END)
FROM 表

[ping3000]

select Person_zhuangtai1 = (case
WHEN bm_yuangong.Person_zhuangtai = 0 THEN '离职'
WHEN bm_yuangong.Person_zhuangtai = 1 THEN '试用在职'
WHEN bm_yuangong.Person_zhuangtai = 2 THEN '正式在职'
else '' END)
FROM 表

[zpzpcncn]

case bm_yuangong.Person_zhuangtai when 0 then '离职' when 1 then '试用在职'
when 2 then '正式在职'
end zhuangtai1
是这样吗？

[ping3000]

或者
select Person_zhuangtai1 = (case Person_zhuangtai
WHEN 0 THEN '离职'
WHEN 1 THEN '试用在职'
WHEN 2 THEN '正式在职'
else '' END)
FROM test

[dawugui]

select
case bm_yuangong.Person_zhuangtai WHEN 0 THEN '离职'
WHEN 1 THEN '试用在职'
WHEN 2 THEN '正式在职'
end as Person_zhuangtai1
from tb

[chang1216]

长见识阿 谢谢

[yaoyaozi]

学习中

[shuai45]

学习啊~~~~
如果是这样的呢
id name sign
1 we 0
2 fd 1
3 fd 2
通过sql写成如下：
id name sign test
1 we 0 离职
2 fd 1 在职
3 f 2 适用

此sql 又如何写呢 请教 上面的兄弟
3 fd 2