I have a query that starts like this...
SELECT COUNT(A.FISH), COUNT(B.MEAT), COUNT(C.FRUIT)....
now my problem is this, how could I count when I need to consider an expiration date for each column,...and the expiration dates varies for each column...
Can I do this in one query?
Or is there any other way I can do to consider the dates for each column?????.....
Need clarification here...
Thank you in advance....