SQL Server 2019

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

CREATE table tableA (id int, 
               created_time datetime,
               Modified_time datetime);
               
INSERT INTO tableA VALUES (23, '2019-01-01', '2022-07-17'),
                          (25, '2019-01-21', '2022-08-17');

CREATE TABLE tableB (id int,
                     Last_7_days int, 
                     Last_30_days int, 
                     updated_time datetime)
                     
INSERT INTO tableB VALUES (23, 0, 0, '2022-08-19'),
                          (23, 0, 0, '2022-10-19'),
                          (23, 0, 0, '2022-09-19'),
                          (23, 0, 0, '2021-12-19'),
                          (23, 0, 0, '2022-04-21'),
                          (23, 0, 0, '2022-06-21'),
                          (23, 0, 0, '2022-07-17');
9 rows affected

select b.*
from tableA a JOIN tableB b on a.id = b.id
--where b.updated_time = a.Modified_time
where b.updated_time between DATEADD(year, -1, a.Modified_time) and a.Modified_time


id
Last_7_days
Last_30_days
updated_time


23
0
0
2021-12-19 00:00:00.000

23
0
0
2022-04-21 00:00:00.000

23
0
0
2022-06-21 00:00:00.000

23
0
0
2022-07-17 00:00:00.000


SELECT DATEADD(year, -1, Modified_time), modified_time
FROM tableA


(No column name)
modified_time


2021-07-17 00:00:00.000
2022-07-17 00:00:00.000

2021-08-17 00:00:00.000
2022-08-17 00:00:00.000

id	Last_7_days	Last_30_days	updated_time
23	0	0	2021-12-19 00:00:00.000
23	0	0	2022-04-21 00:00:00.000
23	0	0	2022-06-21 00:00:00.000
23	0	0	2022-07-17 00:00:00.000

(No column name)	modified_time
2021-07-17 00:00:00.000	2022-07-17 00:00:00.000
2021-08-17 00:00:00.000	2022-08-17 00:00:00.000