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'),
(123457,'ABC123','2021-11-10 14:09:44.920', '2022-05-19 11:13:17.137'),
(123457,'ABC124','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'),
(123456,'ABC123','2021-11-10 14:09:44.920', '2022-05-19 11:13:17.137'),
(123457,'ABC123','2021-11-10 14:09:44.920', '2022-05-06 10:08:09.263'),
(123457,'ABC123','2021-11-10 14:09:44.920', '2022-05-19 11:13:17.137'),
(123457,'ABC124','2021-11-10 14:09:44.920', '2022-05-19 10:08:09.263'),
(123457,'ABC124','2021-11-10 14:09:44.920', '2022-05-19 11:13:17.137');
9 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

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

123457
ABC124
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

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

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

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

123457
ABC124
2021-11-10 14:09:44.920
2022-05-19 10:08:09.263

123457
ABC124
2021-11-10 14:09:44.920
2022-05-19 11:13:17.137


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


ID
Company
Created
Changed


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

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

123457
ABC124
2021-11-10 14:09:44.920
2022-05-19 10:08:09.263


DELETE C
  FROM TableB C
JOIN
(
  SELECT B.ID, B.Company, B.Created, B.Changed 
  FROM TableB B
  INNER JOIN TableA A 
  ON A.ID = B.ID AND A.Company = B.Company
  GROUP BY B.ID, B.Company, B.Created, B.Changed 
  HAVING MIN(B.Changed) < MIN(A.Changed) 
) D ON C.ID = D.ID AND C.Company = D.Company 
AND C.Created = D.Created AND C.Changed = D.Changed 
3 rows affected

SELECT * FROM TableB


ID
Company
Created
Changed


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

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

123457
ABC124
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-19 11:13:17.137
123457	ABC123	2021-11-10 14:09:44.920	2022-05-19 11:13:17.137
123457	ABC124	2021-11-10 14:09:44.920	2022-05-19 11:13:17.137