In my shopping cart project, I intend to select a particular row that falls into certain
conditions. In the table I have columns namely CategoryId,ProductId,Season,SeasonFromMonthNumber
(value is 1) and SeasonToMonthNumber(value is 12).
Now, using the current month number(6), I tested with the following code. The result is nothing.
Can anyone give me the correct code.
SELECT season from product WHERE CategoryId=4 and ProductId=72 and SeasonFromMonthNumber>=6 and SeasonToMonthNumber<=6;