>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)...
ROOMS :
inoroom (Integer, 6, Primary Key)
ctype (Character, 15)
RESERVATIONS :
iid (Integer,6,primary key)
inoro (Integer,6)
dstart (Start date)
dend (End date)
inoroom field is related 1-m with inoro into RESERVATIONS table....
The problem is that I want to see all rooms that are NOT reserved between 2 variables date... Some of these rooms are not present in RESERVATIONS table and some are present betwwen these 2 dates and some on other dates... A room, of course can be reserved during different periodes.... Like a hotel reservation....
Thanks !
Gilles