Checking if the reservation dates are occupied.

[telmessos]

Hi all,

I have a property rental web site and I am adding a search engine to it. There is a table of "booking" which shows the start and end dates of the reservations with the propertycode. I would like to know how I can write an SQL to check if a property is booked between two dates? (My search engine makes a search of location, sublocation, arrival date, departure date, sleeps up to, number of rooms and swimming pool. so it is not a date search only)

Thanks