Re: Hotel Booking dates subquery
From: Damjan S. Vujnovic <damjan_at_NOSPAMgaleb.etf.bg.ac.yu>
Date: Sun, 1 Dec 2002 13:55:08 -0800
Message-ID: <asdlo8$rd7$1_at_news.etf.bg.ac.yu>
: 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')));
Date: Sun, 1 Dec 2002 13:55:08 -0800
Message-ID: <asdlo8$rd7$1_at_news.etf.bg.ac.yu>
: 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 - 22:55:08 CET