Re: Hotel Booking dates subquery
From: Jan Hidders <hidders_at_REMOVE.THIS.uia.ua.ac.be>
Date: 11 Nov 2002 11:46:59 +0100
Message-ID: <3dcf8aa3$1_at_news.uia.ac.be>
Date: 11 Nov 2002 11:46:59 +0100
Message-ID: <3dcf8aa3$1_at_news.uia.ac.be>
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