I'm writing a room booking system to integrate with an existing system. I'm sure the SQL I need has been written before can anyone help.
I have a few tables the key ones are Rooms
I need the sql to select all booked rooms between 2 dates, and all rooms with free slots between 2 dates.
This will be further complicated as I need recurring bookings, but don't know how I'm going to do that yet.