>>Hi !
>>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)...
>>
>>I'm sure it's simple but I can't find the solution... Help !!!
>>
>>Thanks !
>>
>>Gilles
>
>ldStayStart = DATE()
>ldStayEnd = DATE + 5
>
>SELE Rooms.* FROM Rooms WHERE Room.id NOT IN ;
> (SELECT Reservation.roomId FROM Reservation ;
> WHERE !BETWEEN(ldStayStart, reservation.dStart, Reservation.dEnd) ;
> AND !BETWEEN(ldStayEnd, reservation.dStart, Reservation.dEnd)) ;
> INTO CURSOR AvailableRooms
Thanks I'll try !!!
Gilles