Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Hotel Booking dates subquery

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@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.

Received on Mon Nov 11 2002 - 04:46:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US