How to join 2 tables

[#1]

Hi,

I have the below join situation in SQL Server and works fine.

However, how can I create the join in Bold with QV? I can create the #Raw and #Stats within QV and the common fields  BusinessDateand & sUser will create the join I need but how can I create the third join  r.id BETWEEN s.StartID AND s.FinishID

select * from #Raw R

LEFT join #Stats as S

on R.BusinessDate= S.BusinessDate

and R.sUser = S.sUser

AND r.id BETWEEN s.StartID AND s.FinishID

Maybe, I could load the data into another dataset within the Script  but that leaves me with only 1 table effectively, I would like to have 2 and have the join between them.

Thanks very much for any answers.

[hic · Accepted solution]

Use an IntervalMatch: See IntervalMatch

HIC