Check date interval in SELECT

[spacemarc]

Hi
I have 3 fields like this:

id  date_in          date_out
1   2006-09-05   2006-09-10
2   2006-09-15   2006-09-20
3   2006-09-25   2006-09-30

Example: if I have an time interval like '2006-09-05' and '2006-09-21',
I have to search, in the same time, only the records that not included
in time interval and
that they are different is from date_in that from date_out.
In the example above, I would have to obtain only last record (id 3).

Thanks in advance

-- 
http://www.spacemarc.it