Re: Hotel Booking dates subquery

Jan Hidders wrote:
>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.

That's ok, I wasn't entirely sure myself, thanks for checking it over for me.

>Btw., you can still
>simplify your query a litte: you can remove tha -todate(...) everywhere and
>the first and second equations are redundant.

Ok, I'll have a play with it and see what optimisation can be performed. I've yet to put in the check for room status so it should hopefully be a decent query when its done.

Cheers. Received on Mon Nov 11 2002 - 17:33:19 CET