This should be pretty close to what you need, if I understand your
situation:
Select * From mytable
Where
(querydate1 > tabledatelow And querydate1 < tabledatehigh)
And
(querydate2 > tabledatelow And querydate2 < tabledatehigh);
I'm assuming you know which of the two dates in the tab
hello list,
Michael Thygs is right, but the expression can be simplified. We have to
assume that all dates are in correct order, i. e. for each date pair the
following relation is true:
from date <= to date
When a date range from tab1 does NOT overlap a date range from tab2, then
the tab1 ran
