1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
| with TABLE1 as (
select 1 as id,'yop' as lib FROM dual UNION ALL
select 2 as id,'yup' as lib FROM dual UNION ALL
select 2 as id,'yap' as lib FROM dual UNION ALL
select 4 as id,'yip' as lib FROM dual
),
TABLE2 as (
select 1 as id, 'AAA' as libelle FROM dual UNION ALL
select 2 as id, 'BBB' as libelle FROM dual UNION ALL
select 3 as id, 'CCC' as libelle FROM dual UNION ALL
select 1 as id, 'BBB' as libelle FROM dual
),
TABLE2DECODE as (
select id,
CASE
WHEN libelle='AAA' THEN 'aaa'
WHEN libelle='BBB' THEN 'bbb'
WHEN libelle='CCC' THEN 'ccc'
WHEN libelle='DDD' THEN 'ddd'
ELSE 'void'
END as lib
from TABLE2
)
select T2.lib
from TABLE2DECODE T2 JOIN TABLE1 T1 ON T1.id=T2.id |
