这个sql有什么毛病？请帮我看看，谢谢

[bsd]

CREATE VIEW employee_view
AS
select a.objid, a.employee_id, a.local_name,
english_name = isNull(b.english_name,a.english_name),
a.email,
department = isNull(b.department,a.org_name) ,
a.proxy_id,
status = IIf(a.on_duty,'resign','on duty'),
a.extension
from employee_a as a left join employee_b as b
on a.employee_id = b.employee_id

[pengdali]

CREATE VIEW employee_view
AS
select a.objid, a.employee_id, a.local_name,
english_name = isNull(b.english_name,a.english_name),
a.email,
department = isNull(b.department,a.org_name) ,
a.proxy_id,
status = case when a.on_duty=1 then 'resign' else 'on duty' end,
a.extension
from employee_a as a left join employee_b as b
on a.employee_id = b.employee_id

[j9988]

是用SQL SERVER ?
status = IIf(a.on_duty,'resign','on duty')---->

status = (case when a.on_duty=1 then 'resign' else 'on duty' end)

[bsd]

谢谢。
不过很奇怪，难道IIF不能这么用吗？
第一个参数不是可以为logical expression?

[leimin]

iif()中第一个参数不是可以为logical expression,你要加个判断,比如isnumeric(a.on_duty)或你自定义一个函数,返回1/0.