Re: Hotel Booking dates subquery

From: Jan Hidders <>
Date: 11 Nov 2002 11:46:59 +0100
Message-ID: <3dcf8aa3$>

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
Received on Mon Nov 11 2002 - 11:46:59 CET

Original text of this message