Re: Hotel Booking dates subquery
Date: 11 Nov 2002 11:46:59 +0100
>Jan Hidders 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