Master table
create table master_table(mast_id number, jira_status varchar2(50));
insert into master_table values(1,'In DEV');
insert into master_table values(2,'In SIT');
insert into master_table values(3,'In UAT');
Main table
create table tab_main(id_num number, first_name, jira_code);
insert into tab_main(1,'A',--Here I want to fetch the code from master_table)
Finally, I want a report where in I would select required columns
select tm.id_num, tm.first_name, mt.jira_status from main able and master table