: Hate to bring up the dead, but might this also work?
:
: SELECT room_id
: FROM rooms
: WHERE room_id NOT in (
: SELECT distinct room_id
: FROM bookings
: WHERE status = 'occupied'
: AND (start_date,end_date)
: OVERLAPS(to_date('02/02/03','DD/MM/YY'),
: to_date('07/02/03','DD/MM/YY')));
Looks good to me...
--
regards,
Damjan S. Vujnovic
University of Belgrade
School of Electrical Engineering
Department of Computer Engineering & Informatics
Belgrade, Yugoslavia
http://galeb.etf.bg.ac.yu/~damjan/
Received on Sun Dec 01 2002 - 15:55:08 CST
