>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