I have an app where I record requests for bookings. I need to be able to check if a requested date is already booked. I have read a bit in the community and found that this could be done with self join relationships.
From a technical perspective I have a table called Requests with the following fields:
Booked entries are the records in the same table that have entries in Arrival and Departure.
So, if I resolve this via self join relationships I would need somehow to have any existing Arrival or Departure to be within the ExpectedArrival and the ExpectedDeparture.
Any suggestions how should I do this ?