This is a simplified case.

The given is a month number. For example, May is 5. Or it could be any month from 1 to 12.

I have a table, SCHEDULE, which specifies frequency and a month no. For simplicity, this table has just two columns, FREQ and MONTH

FREQ  		MONTH
2		       4
6		       6
1		       3
2                  11
12		      1

The frequency is how many times a year. For example, frequency 6 means 6 times; frequency 2, 2 times.

The Month specifies the month from which to determine the scheduled months. For example,
Frequency 2 and Month 4 means:
Month 4
Month 10
(6 months apart)

Another example,
Frequency 12 and Month 1, mean every month. Or it could be Frequency 12 and month 2. Still, each month.

My question, can I create a SQL Select of records where the “scheduled” month is 5 (or whatever given number).
That is, for example the row of FREQ 2 and Month 4 will not be included because they set the schedule for Months 4 and 10 (neither one is 5). But the row Frequency 2 and Month 11 will be selected since this record will create a schedule for Month 11 and Month 5.

I know how to do it a long way. That is, scan each record of the above table, determine which months are affected and exclude those that don’t have the specified month.

But I wonder if it can be done in one SQL Select

TIA