Re: Hotel Booking dates subquery
From: Scotty <invallid_at_invalid.spam>
Date: Mon, 11 Nov 2002 19:10:49 +0000
Message-ID: <t200tukkc70uigj9jlctmsacjlk37amimq_at_4ax.com>
Date: Mon, 11 Nov 2002 19:10:49 +0000
Message-ID: <t200tukkc70uigj9jlctmsacjlk37amimq_at_4ax.com>
Jan Hidders wrote:
>Ahem, :-), you need to swap the 17-11-02 and the 20-11-02, and, yes, I did
>check if I read the '<' and '>' correctly. :-) Remember that the formula was:
>
> end1 < begin2 or begin1 > end2
>
>where one period is [begin1, end1] and the other period is [begin2, end2].
It's all in vain Jan, Damjam has just put the mockers on my query, It needs something of an overhaul. Received on Mon Nov 11 2002 - 20:10:49 CET