QUERY DIFFERENT TABLES DEPENDING ON VALUE

[fragolita]

Hi all!

I have to create the following report:

1. I query column1,column2 from Table A
2. depending on column2 value I have to access to different tables: B1, B2 to get more information which must be displayed on my report

How can i do it??
Can you recommend me some tutorial?
Thanks!!

 

[nagornyi]

You may try using DECODE, something like

select
a.column1
, a.column2
, DECODE(a.column2, 'B1', b1.value, 'B2', b2.value)
from
...