Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!cyclone1.gnilink.net!news-out.nuthinbutnews.com!propagator2-sterling!news-in-sterling.newsfeed.com!news-in.nuthinbutnews.com!news.stealth.net!news.stealth.net!kibo.news.demon.net!demon!diablo.theplanet.net!news.theplanet.net!not-for-mail From: Scotty Newsgroups: comp.databases.theory Subject: Re: Hotel Booking dates subquery Date: Mon, 11 Nov 2002 19:10:49 +0000 Lines: 11 Message-ID: References: <5dkosuog0v9698ei9juhfbm2pull0nqqn2@4ax.com> <3dcf8aa3$1@news.uia.ac.be> <5nmvsucjj76c2cgbpi5mfa23mvd96mvi1t@4ax.com> <1jovsuchv3ecsei9l887gjtofafsgdtk6q@4ax.com> <3dcfeaed$1@news.uia.ac.be> 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 1037041842 13186 81.77.121.64 (11 Nov 2002 19:10:42 GMT) NNTP-Posting-Date: 11 Nov 2002 19:10:42 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:23572 X-Received-Date: Mon, 11 Nov 2002 12:10:27 MST (news.easynews.com) Jan Hidders wrote: >Ahem, :-), you need to swap the 17-11-02 and the 20-11-02, and, yes, I did >check if I read the '<' and '>' correctly. :-) Remember that the formula was: > > end1 < begin2 or begin1 > end2 > >where one period is [begin1, end1] and the other period is [begin2, end2]. It's all in vain Jan, Damjam has just put the mockers on my query, It needs something of an overhaul.