Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table table1 (id number, name varchar2(30), date_period number);
select * from table1
insert into table1 values(1,'conan',201906);
1 rows affected

insert into table1  values(1,'conan',202012);
1 rows affected

insert into table1  values(1,'conan',20183112);
1 rows affected

insert into table1  values (2,'andy',201903);
1 rows affected

create table table2   (id number, profile varchar2(30), year number,period number);
insert into table2  values (1,'host',2019,6);
1 rows affected

insert into table2  values (1,'screeenwriter',2018,3112);
1 rows affected

insert into table2  values (1,'anchor',2020,12);
1 rows affected

insert into table2  values (2,'sidekick',2019,3);
1 rows affected

select * from table2 ;


ID
PROFILE
YEAR
PERIOD


1
host
2019
6

1
screeenwriter
2018
3112

1
anchor
2020
12

2
sidekick
2019
3


select * from table1


ID
NAME
DATE_PERIOD


1
conan
201906

1
conan
202012

1
conan
20183112

2
andy
201903


select
 *
from table2 t2
inner join table1 t1 on t1.id = t2.id and t1.date_period= (t2.year*100+t2.period)


ID
PROFILE
YEAR
PERIOD
ID
NAME
DATE_PERIOD


1
host
2019
6
1
conan
201906

1
anchor
2020
12
1
conan
202012

2
sidekick
2019
3
2
andy
201903


select concat(year,month) from table2
ORA-00904: "MONTH": invalid identifier

ID	PROFILE	YEAR	PERIOD	ID	NAME	DATE_PERIOD
1	host	2019	6	1	conan	201906
1	anchor	2020	12	1	conan	202012
2	sidekick	2019	3	2	andy	201903