Date Question

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 2 dates, 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 example a 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 getting the 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