Oracle 11.2.0.4
Forms 6i
A user enters the date range From and To and the query needs to show which properties are vacant during this date range.
I have two tables SERVICE_UNITS and OCCUPANCY.
Service units table has property_code and Property_address while Occupancy table has property_code, status (Active,New), start_date and End_date
Suppose a property is active from 16-NOV-2022 till 20-NOV-2022 and an advance booking has been done for same property from 25-NOV-2022 till 30-NOV-2022.
how can i show the properties which aren't booked during any given range.
Best Regards,