1.from a in alarmsfrom t in testPeriods
wherea.Overlaps(b)select a
2.from a in alarms
from t in testPeriodsselect a
3.from a in alarmsfrom t in testPeriods
wherea.Time>t.StartTime&&a.Time<t.EndTimeselect a
4.from a in alarmsjoin t in testPeriodson a equals tselect a