Oracle Sql根据不同取值选择不同的表

select case i_code when 1 then a.code
                          when 2 then b.code
                                     end as code
from a left join b on 1=1
          left join c on 1=1
          left join d on 1=1
;