>How about:
>
>
SELECT Rooms.iNoRoom;
> FROM Rooms;
> WHERE Rooms.iNoRoom NOT EXIST IN;
> (SELECT Reservations.iNoRo;
> FROM Reservations;
> WHERE (ldStart BETWEEN dStart AND dEnd) OR;
> (ldEnd BETWEEN dStart AND dEnd))
Where ldStart and ldEnd are the start and end date of the reservation you are trying to make.
>
>HTH
>
>>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 a lot !
Gilles