select tb_TXLC.AID, (case when ISNUMERIC(tb_TXLC.InvolvedDept)!=0 then tb_Tree.NodeName else tb_TXLC.InvolvedDept end) as InvolvedDept,FlowNode
from tb_TXLC left outer join tb_Tree on tb_Tree.TreeID=case when ISNUMERIC(tb_TXLC.InvolvedDept)!=0 then convert(int,tb_TXLC.InvolvedDept) else 0 end
where tb_TXLC.FlowType='WJSK' order by tb_TXLC.AID desc
select AID,InvolvedDept from tb_TXLC where tb_TXLC.FlowType='WJSK' order by AID desc