Join to tables link field between 2 values

harishgg1 · February 6, 2023, 12:09pm

hi hope this helps

create data script

drop table #Table2
drop table #Table1

create table #Table1 (EntryNo int , PostingDate date , RegisteredDate date )
insert into #Table1 select 1050,'03-01-2023','01-01-2023'
insert into #Table1 select 1250,'01-01-2023','02-01-2023'

create table #Table2 (FromEntryNo int , ToEntryNo int , RegisteredDate date )
insert into #Table2 select 1000,1200,'01-01-2023'
insert into #Table2 select 1201,1300,'02-01-2023'

select 
          * 
from 
       #Table1, #Table2 
where 
       EntryNo >= FromEntryNo
              and 
       EntryNo <= ToEntryNo