MySQL 8.0

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

create table roles (
id int ,
title varchar(50)  );

insert into roles values 
(1,'Manager'),
(2,'Project lead'),
(3,'Computer Engineer');

create table employee (
id int ,
first_name varchar(50),
 role_id int );

insert into employee values 
(1,'Jane',1),
(2,'Patrick',2),
(3,'Robert',3);
select * from roles;
select * from employee;


id
title


1
Manager

2
Project lead

3
Computer Engineer




id
first_name
role_id


1
Jane
1

2
Patrick
2

3
Robert
3


select e.id,
       e.first_name,
       r.title
from roles r 
inner join employee e on e.role_id=r.id;


id
first_name
title


1
Jane
Manager

2
Patrick
Project lead

3
Robert
Computer Engineer