SQL Query Question

Classic Servoy
1

I am wondering if the following query and report is possible?

Again this is from the Hotel Reservation system. Each reservation record has a hotel, an indate and an outdate + a number of rooms. Many of those reservations have an indate in one month and an outdate in another. I need to be able to produce a report that shows the total number of rooms sold for every day in each month. I know that I can do it by creating records (in a related table) for every day in between the in and outdates but is it possible to do this without creating the extra table and records?

TIA

2

This is typically a request that can easily be solved using SQL.

Can you send me your solution? (with example data)
I’ll type the query for you.

  1. where exactly would you want your report to show up?
    (as a general overview of all hotelrooms, or a view per hotel/roomrecord?)
    (maybe you can attach an image of how your report should exactly look like?)