select t.id,
t.title,
decode(subflag,'1','待批','2',decode(sh_flag,'01','采纳','02','不采纳',''),'') as subflag
from task_dongyi_info t
注意:
decode():把流程中为1的显示待批,为2的流程结束为结束流程,然后结束流程中为01的显示采纳,02显示不采纳
select t.id,
t.title,
decode(subflag,'1','待批','2',decode(sh_flag,'01','采纳','02','不采纳',''),'') as subflag
from task_dongyi_info t
注意:
decode():把流程中为1的显示待批,为2的流程结束为结束流程,然后结束流程中为01的显示采纳,02显示不采纳