|
例如:
select org_tempInfo,org_tempInfo.fabbrname as fabbrname,org_tempInfo.focs as focs,org_tempInfo.focsname as focsname,org_tempInfo.fbcs as fbcs,org_tempInfo.fbcsname as fbcsname,org_tempInfo.fchktype as fchktype,org_tempInfo.fchktypename as fchktypename,case when org_tempInfo.fchktype = 1 then org_tempInfo.fbcsname when org_tempInfo.fchktype = 2 then org_tempInfo.fbcsname when org_tempInfo.fchktype = 3 then org_tempInfo.fbcsname when org_tempInfo.fchktype = 4 then org_tempInfo.focsname when org_tempInfo.fchktype = 5 then org_tempInfo.focsname else org_tempInfo.focsname end as fstatus
from org_tempInfo org_tempInfo
能否得出我想要的fstatus字段的值?
|
|