SQL & PL/SQL

Hello All,

I am new to PL/SQL and trying to write conditional statement in join condition like below.

I hope this would be allowed in Oracle PL/SQL)

select

Table1.*

from

Table1 Table1

LEFT OUTER JOIN  Table2 Table2 

    ON 

     (

    CASE

         WHEN

           Table1.column1 like 'DEDUCTABLE%'

      THEN (Table1.column2=Table2.col1 OR Table1.column2=Table2.col2)

      WHEN

           Table1.column1 like 'COINSURANCE%'

      THEN (Table1.column2=Table2.col3 OR Table1.column2=Table2.col4)

          WHEN

           Table1.column1 like 'COPAY%'

      THEN (Table1.column2=Table2.col5 OR Table1.column2=Table2.col6)

    END

   )

Thanks,