Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!mango.news.easynet.net!easynet.net!Quza.UK.peer!nntp.gblx.net!diablo.netcom.net.uk!netcom.net.uk!nntp.theplanet.net!inewsm1.nntp.theplanet.net!news.theplanet.net!not-for-mail
From: Scotty <invallid@invalid.spam>
Newsgroups: comp.databases.theory
Subject: Re: Hotel Booking dates subquery
Date: Mon, 11 Nov 2002 19:09:14 +0000
Lines: 8
Message-ID: <ftvvsuke0c850246c7eeb1r5fo2r0ugtu7@4ax.com>
References: <5dkosuog0v9698ei9juhfbm2pull0nqqn2@4ax.com> <raftsu498s3kg87smfa9m3n56fpto8h6ud@4ax.com> <3dcecc70$1@news.uia.ac.be> <ajptsu4fo8c22u6edrlhc95ffeht6udfn5@4ax.com> <3dcf0255$1@news.uia.ac.be> <aenusu0rolqjlrsai6njprrpm8apmnv1tu@4ax.com> <aqol9s$i8r$1@news.etf.bg.ac.yu>
NNTP-Posting-Host: 81.77.121.64
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: newsg4.svr.pol.co.uk 1037041747 13186 81.77.121.64 (11 Nov 2002 19:09:07 GMT)
NNTP-Posting-Date: 11 Nov 2002 19:09:07 GMT
X-Complaints-To: abuse@theplanet.net
Summary: YHBT
X-Newsreader: Forte Agent 1.8/32.548
X-No-Archive: yes
Xref: newsfeed1.easynews.com comp.databases.theory:23571
X-Received-Date: Mon, 11 Nov 2002 12:08:51 MST (news.easynews.com)

Damjan S. Vujnovic wrote:

>Your query will say (again) that rooms 1 and 6 were free, but room 1 wasn't
>it was occupied between 13-NOV-02 and 17-NOV-02!

Damnit this stuff is tricky. Thanks for the info Damjam. I have that
query you showed me up and running, but i'd like to get the one I
started working - it's become an obsession....