oracle case when 

select a.*,
       case
         when a.type = 'executeUnit' then 
          (select e.name from diqm_quality_executeunit e where e.id = a.reference) 
         when a.type = 'analyzer' then 
          (select e.name from diqm_quality_analyzer e where e.id = a.reference) 
          else    
          ''
          end name
     
from diqm_quality_analyzerrelation a

 

posted @ 2016-04-27 10:18  IAMME  阅读(133)  评论(0)  编辑  收藏  举报