Date condition in Qlivkiew SQL

[Prabhu1204]

I am generating a qvd in Qlikview. Fetching  details from DB. 

Having a where condition like cal_month=12  and cal_days between 12 and 5.

How to achieve If I need to add on few cal months and cal days like cal_month = 5 and cal_days= 10 and 15.

I tired giving condition like where( cal_month = 12 and cal_days  between 12 and 5) and ( cal_month = 5 and cal_days  between 10 and 5) . Bit it seems to take more memory and it looks like wrong condition

[Prabhu1204 · Accepted solution]

Got  it.. Giving both condition like below works,

where (cal_date =12 and cal_days between 10 and 15 OR cal_date= 5 and cal_days between 10 and 15)