Can you give the structure of your tables?

>I have a logical problem... I work on a room reservation application : I have one database with all the ROOMS and one with reservations with a start date and an end date...
>I would like to do a view to visualize all the ROOMS that are not reserved between two dates (variables)...