Re: Hotel Booking dates subquery
From: Scotty <invallid_at_invalid.spam>
Date: Mon, 11 Nov 2002 19:09:14 +0000
Message-ID: <ftvvsuke0c850246c7eeb1r5fo2r0ugtu7_at_4ax.com>
Date: Mon, 11 Nov 2002 19:09:14 +0000
Message-ID: <ftvvsuke0c850246c7eeb1r5fo2r0ugtu7_at_4ax.com>
Damjan S. Vujnovic wrote:
>Your query will say (again) that rooms 1 and 6 were free, but room 1 wasn't
>it was occupied between 13-NOV-02 and 17-NOV-02!
Damnit this stuff is tricky. Thanks for the info Damjam. I have that query you showed me up and running, but i'd like to get the one I started working - it's become an obsession.... Received on Mon Nov 11 2002 - 20:09:14 CET