SQL Server 2019

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

CREATE TABLE TableA (
  ID INT,
  Company varchar(50),
  Created DATETIME,
  Changed DATETIME
);

CREATE TABLE TableB (
  ID INT,
  Company varchar(50),
  Created DATETIME,
  Changed DATETIME
);

INSERT INTO TableA (ID, Company, Created, Changed)
VALUES
(123456,'ABC123','2021-11-10 14:09:44.920', '2022-05-19 11:13:17.137')

INSERT INTO TableB (ID, Company, Created, Changed)
VALUES
(123456,'ABC123','2021-11-10 14:09:44.920', '2022-05-06 10:08:09.263')
2 rows affected

SELECT * FROM TableA


ID
Company
Created
Changed


123456
ABC123
2021-11-10 14:09:44.920
2022-05-19 11:13:17.137


SELECT * FROM TableB


ID
Company
Created
Changed


123456
ABC123
2021-11-10 14:09:44.920
2022-05-06 10:08:09.263


SELECT A.ID, A.Company, A.Created, A.Changed 
FROM TableA A
INNER JOIN TableB B
ON A.ID = B.ID AND A.Company = B.Company
GROUP BY A.ID, A.Company, A.Created, A.Changed 
HAVING MAX(A.Changed) > MAX(B.Changed) 


ID
Company
Created
Changed


123456
ABC123
2021-11-10 14:09:44.920
2022-05-19 11:13:17.137


INSERT INTO TableB (ID, Company, Created, Changed)
SELECT A.ID, A.Company, A.Created, A.Changed 
FROM TableA A
INNER JOIN TableB B
ON A.ID = B.ID AND A.Company = B.Company
GROUP BY A.ID, A.Company, A.Created, A.Changed 
HAVING MAX(A.Changed) > MAX(B.Changed) 
1 rows affected

SELECT * FROM TableB


ID
Company
Created
Changed


123456
ABC123
2021-11-10 14:09:44.920
2022-05-06 10:08:09.263

123456
ABC123
2021-11-10 14:09:44.920
2022-05-19 11:13:17.137

ID	Company	Created	Changed
123456	ABC123	2021-11-10 14:09:44.920	2022-05-06 10:08:09.263
123456	ABC123	2021-11-10 14:09:44.920	2022-05-19 11:13:17.137