是2005的,
select UserGUID,UserName,PId,LoginName,Mobile,LastLoginTime,
case when UserState=0 then '未审核'
when UserState=1 then '审核'
end as UserState
from UserInfo,MobileInfo
where UserInfo.MobileGUID=MobileInfo.MobileGUID and UserInfo.UserState=0
order by LastLoginTime比如这样未审核和审核都是乱码,怎么办?
select UserGUID,UserName,PId,LoginName,Mobile,LastLoginTime,
case when UserState=0 then '未审核'
when UserState=1 then '审核'
end as UserState
from UserInfo,MobileInfo
where UserInfo.MobileGUID=MobileInfo.MobileGUID and UserInfo.UserState=0
order by LastLoginTime比如这样未审核和审核都是乱码,怎么办?
select UserGUID,UserName,PId,LoginName,Mobile,LastLoginTime,
case when UserState=0 then N'未审核'
when UserState=1 then N'审核'
end as UserState
from UserInfo,MobileInfo
where UserInfo.MobileGUID=MobileInfo.MobileGUID and UserInfo.UserState=0
order by LastLoginTime