It depends on the exact results you want.
One way to do that is to join the two tables:
from dbo.MyTable1 as T1
inner join dbo.MyTable2 as T2
on T2.DateColumn between T1.DateColumn1 and T1.DateColumn2;
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon