T1
     
ID	Balance
1	500
2	50
3	1000
 
T2
 
     
Min	Max	Int
0	100	2
101	500	1
501	1000 3

Output required
 
     
ID	R1	R2	R3	R1_int	R2_int	R3_int
1	0	500	0	0	1	0
2	50	0	0	2	0	0
3	0	0	1000	0	0	3
 

create table T1(id number,balance number);
create table T2(min number,max number,int number);
 
insert into T1
select 1,500 from dual
union all
select 2,50 from dual
union all
select 3,1000 from dual;
 
insert into T2
select 0,100,2 from dual
union all
select 101,500,1 from dual
union all
select 501,1000,3 from dual;

select a.id,case when a.balance between b.min and b.max then a.balance else 0 end from T1 a, T2 b 
group by a.id,
a.balance,
b.min,
b.max;

SELECT    t1.id
,         CASE WHEN t2.int = 2 THEN t1.balance ELSE 0 END   AS r1
,         CASE WHEN t2.int = 1 THEN t1.balance ELSE 0 END   AS r2
,         CASE WHEN t2.int = 3 THEN t1.balance ELSE 0 END   AS r3
FROM      t1
JOIN      t2   ON   t1.balance  BETWEEN  t2.min
                                AND      t2.max
ORDER BY  t1.id

SELECT    t1.id
,         CASE WHEN t2.int = 2 THEN t1.balance ELSE 0 END   AS r1
,         CASE WHEN t2.int = 1 THEN t1.balance ELSE 0 END   AS r2
,         CASE WHEN t2.int = 3 THEN t1.balance ELSE 0 END   AS r3
FROM      t1
cross join t2;

ID	R1	R2	R3
1	500	0	0
2	50	0	0
3	1000	0	0
1	500	0	0
2	50	0	0
3	1000	0	0
1	0	500	0
2	0	50	0
3	0	1000	0
1	0	500	0
2	0	50	0
3	0	1000	0
1	0	0	500
2	0	0	50
3	0	0	1000
1	0	0	500
2	0	0	50
3	0	0	1000

SELECT   *
FROM      t1
cross join t2;

ID	BALANCE	MIN	MAX	INT
1	500	0	100	2
2	50	0	100	2
3	1000	0	100	2
1	500	0	100	2
2	50	0	100	2
3	1000	0	100	2
1	500	101	500	1
2	50	101	500	1
3	1000	101	500	1
1	500	101	500	1
2	50	101	500	1
3	1000	101	500	1
1	500	501	1000	3
2	50	501	1000	3
3	1000	501	1000	3
1	500	501	1000	3
2	50	501	1000	3
3	1000	501	1000	3

ID	BALANCE	MIN	MAX	INT
1	500	0	100	2
1	500	0	100	2
1	500	101	500	1
1	500	101	500	1
1	500	501	1000	3
1	500	501	1000	3
2	50	0	100	2
2	50	0	100	2
2	50	101	500	1
2	50	101	500	1
2	50	501	1000	3
2	50	501	1000	3
3	1000	0	100	2
3	1000	0	100	2
3	1000	101	500	1
3	1000	101	500	1
3	1000	501	1000	3
3	1000	501	1000	3

each row i wanted something like this

expalined the first row

ID	BALANCE	MIN	MAX	INT	R1	R2	R3	R4	R1_INT	R2_INT	R3_INT	R4_INT
1	500	0	100	2	0	500	0	0	0	2	0	0
1	500	0	100	2								
1	500	101	500	1								
1	500	101	500	1								
1	500	501	1000	3								
1	500	501	1000	3								
2	50	0	100	2								
2	50	0	100	2								
2	50	101	500	1								
2	50	101	500	1								
2	50	501	1000	3								
2	50	501	1000	3								
3	1000	0	100	2								
3	1000	0	100	2								
3	1000	101	500	1								
3	1000	101	500	1								
3	1000	501	1000	3								
3	1000	501	1000	3								

SQL> select t1.id,
  2         max(case when t2.id = 1 and t1.balance between t2.min and t2.max then t1.balance else 0 end) r1,
  3         max(case when t2.id = 2 and t1.balance between t2.min and t2.max then t1.balance else 0 end) r2,
  4         max(case when t2.id = 3 and t1.balance between t2.min and t2.max then t1.balance else 0 end) r3,
  5         max(case when t2.id = 1 and t1.balance between t2.min and t2.max then t2.int else 0 end) r1_int,
  6         max(case when t2.id = 2 and t1.balance between t2.min and t2.max then t2.int else 0 end) r2_int,
  7         max(case when t2.id = 3 and t1.balance between t2.min and t2.max then t2.int else 0 end) r3_int
  8  from t1, ( select t2.*, row_number() over (order by min) id from t2 ) t2
  9  group by t1.id
 10  order by t1.id
 11  /
        ID         R1         R2         R3     R1_INT     R2_INT     R3_INT
---------- ---------- ---------- ---------- ---------- ---------- ----------
         1          0        500          0          0          1          0
         2         50          0          0          2          0          0
         3          0          0       1000          0          0          3