Hi,
I have a query that is not returning the desired results. I want the results to be a list of permit_id's held between
2dates, but the results I'm getting is only those permit_id's that start on date_from ('27-06-02') and finish on
date_to('11-07-02'), I also want the permit_id's returned for those permits that are held within that time period, for
examplea permit that starts on 20-06-02 and finishes on 04-07-02. I've tried all sorts of variations but I'm still not
gettingthe right results, anyone have any ideas?
SELECT permit_id
FROM faps_permit
WHERE person_id = (select person_id from person where person_id = 100)
AND cancel_permit is null
AND location = 'Kent Forest'
AND ( (date_from >= '27-06-02' AND date_to <= '11-07-02')
OR (date_from <= '27-06-02' AND date_to >= '11-07-02') )
ORDER BY permit_id ;
(Please note that this query is being used in a Java application and the values shown here are examples)
Regards,
Sharon Cowling