make a query for each date?

From: Christopher Pisz <nospam_at_somewhere.com>
Date: Fri, 19 Jul 2002 20:46:34 GMT
Message-ID: <KU_Z8.59320$88.950011_at_twister.austin.rr.com>

I need to do 2 queries for each date given, instead of making all these seperate queries can I combine them with some kind of for each date between these given , code? Does such a thing exist?

here is my queries:

SELECT S.FLT_DATE, S.FLT_NUM, S.SERIAL_NUM, COUNT(R.CUST_NUM) AS SEATS_RESV,  T.CAPACITY-COUNT(R.CUST_NUM) AS SEATS_AVAIL FROM SCHEDULED_FLT S, AIRCRAFT A, AC_TYPE T, RESERVATION R WHERE S.SERIAL_NUM = A.SERIAL_NUM(+) AND

 A.AC_TYPE = T.AC_TYPE(+) AND
 S.FLT_DATE = R.FLT_DATE(+) AND
 S.FLT_NUM = R.FLT_NUM(+) AND
 S.FLT_DATE = '12-MAY-02'

GROUP BY S.FLT_DATE, S.FLT_NUM, S.SERIAL_NUM, T.CAPACITY; SELECT COUNT(DISTINCT S.FLT_NUM) AS TOTAL_FLIGHTS, COUNT(R.CUST_NUM) AS SEATS_RESV
FROM SCHEDULED_FLT S, RESERVATION R
WHERE S.FLT_DATE = R.FLT_DATE(+) AND
 S.FLT_NUM = R.FLT_NUM(+) AND
 S.FLT_DATE = '12-MAY-02'; and the same for 13-may-02 and 14-may-02 and so on....

Thnx,
Christopher Received on Fri Jul 19 2002 - 22:46:34 CEST