Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!c02.atl3!news.webusenet.com!syros.belnet.be!naxos.belnet.be!news.belnet.be!news.uia.ac.be!not-for-mail From: hidders@REMOVE.THIS.uia.ua.ac.be (Jan Hidders) Newsgroups: comp.databases.theory Subject: Re: Hotel Booking dates subquery Followup-To: comp.databases.theory Date: 11 Nov 2002 11:46:59 +0100 Organization: University of Antwerp Lines: 17 Message-ID: <3dcf8aa3$1@news.uia.ac.be> References: <5dkosuog0v9698ei9juhfbm2pull0nqqn2@4ax.com> <3dcf0255$1@news.uia.ac.be> Reply-To: hidders@uia.ua.ac.be (Jan Hidders) NNTP-Posting-Host: hnets.uia.ac.be X-Trace: naxos.belnet.be 1037011621 21958 143.169.254.1 (11 Nov 2002 10:47:01 GMT) X-Complaints-To: abuse@belnet.be NNTP-Posting-Date: Mon, 11 Nov 2002 10:47:01 +0000 (UTC) X-Newsreader: trn 4.0-test76 (Apr 2, 2001) Originator: hidders@hcoss.uia.ac.be (Jan Hidders) X-Original-NNTP-Posting-Host: hmacs.uia.ac.be X-Original-Trace: 11 Nov 2002 11:46:59 +0100, hmacs.uia.ac.be Xref: newsfeed1.easynews.com comp.databases.theory:23531 X-Received-Date: Mon, 11 Nov 2002 03:46:47 MST (news.easynews.com) Scotty wrote: >Jan Hidders wrote: >>Scotty wrote: >>>I'm curious to ask whether you think the theory behind my query works >>>or not, given test data that reasonable constraints would allow. >> >>Run the test and you will know. If it finds the right bookings your theory >>is correct, if it doesn't it's false. > >Then it's correct. Yes, it is. Somehow I seemed to have swapped the '<' for '>' when I first read your query. My apologies for the misunderstanding. Btw., you can still simplify your query a litte: you can remove tha -todate(...) everywhere and the first and second equations are redundant. -- Jan Hidders