I need suggestion on a conditional query in Oracle like the followings.
say I have a table TBL1 with field1,field2 and field3.
I want to have select statement like the following
if TBL1.field1= 'X' then TBL1 left join TBL2
if TBL1.field1= 'Y' then TBL1 left join TBL3
if TBL1.field1= 'Z' then TBL1 left join TBL4