I am building a booking app and part of this involves reserving a courtesy car.
Courtesy cars can be booked out for a period, e.g.
2nd April - 11 April 12 April - 19 April etc...
These dates are stored in a courtesycarbooking table.
What I want to write is a query which can query the courtesycar and courtesycarbooking tables (they are related) for free dates. Free dates are those which are NOT in the booking table.
How could/should a query like this be written?