MySQL 8.0

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

create table A (ID int, id_update_dt date);
insert into A values(100067842   ,'2021-3-27');
insert into A values(100100227   ,'2021-3-27');
insert into A values(100319616   ,'2021-3-25');
insert into A values(100344419   ,'2021-3-27');
insert into A values(100464912   ,'2021-3-27');
insert into A values(100570028   ,'2021-3-25');
insert into A values(100608364   ,'2021-3-27');
insert into A values(100624076   ,'2021-3-25');
insert into A values(100643085   ,'2021-3-27');
insert into A values(100645028   ,'2021-3-27');
create table B (ID int, id_update_dt date);
insert into B values(100067842   ,'2021-3-25');
insert into B values(100100227   ,'2021-3-25');
insert into B values(100319616   ,'2021-3-25');
insert into B values(100344419   ,'2021-3-25');
insert into B values(100464912   ,'2021-3-25');
insert into B values(100570028   ,'2021-3-25');
insert into B values(100608364   ,'2021-3-25');
insert into B values(100624076   ,'2021-3-25');
insert into B values(100643085   ,'2021-3-25');
insert into B values(100645028   ,'2021-3-25');
select
A.ID, A.id_update_dt
from
A inner join B
  on A.ID = B.ID
and A.id_update_dt> B.id_update_dt


ID
id_update_dt


100067842
2021-03-27

100100227
2021-03-27

100344419
2021-03-27

100464912
2021-03-27

100608364
2021-03-27

100643085
2021-03-27

100645028
2021-03-27

ID	id_update_dt
100067842	2021-03-27
100100227	2021-03-27
100344419	2021-03-27
100464912	2021-03-27
100608364	2021-03-27
100643085	2021-03-27
100645028	2021-03-27