MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table table1 (
  ID	int,
  Date	date,
  emp_code varchar(20),	
  PMS int
);

insert into table1 values
(1,	'2023-12-01',	'V1856',	5),
(2,	'2023-12-10',	'V2584',	4),
(3,	'2023-12-15',	'V3643',	5),
(4,	'2023-12-15',	'V1856',	5),
(5,	'2023-12-16',	'V2584',	6);

Records: 5  Duplicates: 0  Warnings: 0


create table table2 (
  ID	int,
  Date	date,
  emp_code varchar(20),	
  PMS int
);

insert into table2 values
(1,	'2023-12-01',	'V1856',	4),
(2,	'2023-12-10',	'V2584',	4),
(3,	'2023-12-15',	'V3643',	5),
(4,	'2023-12-15',	'V1856',	5),
(5,	'2023-12-16',	'V2584',	2);

Records: 5  Duplicates: 0  Warnings: 0


select t1.ID, t1.Date, t1.emp_code, t1.PMS as tbl1_PMS, t2.PMS as tbl2_PMS 
from table1 t1
inner join table2 t2 on t1.ID = t2.ID 
                    and t1.Date = t2.Date
                    and t1.emp_code = t2.emp_code
where t1.PMS <> t2.PMS


ID
Date
emp_code
tbl1_PMS
tbl2_PMS


1
2023-12-01
V1856
5
4

5
2023-12-16
V2584
6
2