Hello Everyone,
please, could you advice me, how to join "Table 1" and "Mapping table" for "Results".
Thank you.
create table Table_1 (ID1 VARCHAR2(10 CHAR), ID2 VARCHAR2(10 CHAR));
insert into Table_1 values ('12','A');
insert into Table_1 values ('12','B');
insert into Table_1 values ('12','C');
insert into Table_1 values ('12','D');
insert into Table_1 values ('13','X');
insert into Table_1 values ('13','Y');
insert into Table_1 values ('14','Z');
create table Mapping_table_1 (ID1 VARCHAR2(10 CHAR), ID2 VARCHAR2(10 CHAR), CNTR VARCHAR(15 CHAR));
insert into Mapping_table_1 values ('12','A','one');
insert into Mapping_table_1 values ('12','B','two');
insert into Mapping_table_1 values ('12','%','three');
insert into Mapping_table_1 values ('13','%','four');