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

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