Re: Booking System - Vacant room report

On Tue, 18 Mar 2008 13:17:33 +1100, Peter Sutton
<psutton@xxxxxxxxxxxxxxx> wrote:

All temporary tables can be replaced by queries.
-Tom.



Greetings all,

My booking system includes 2 tables:
tblRooms with the key field RoomID, and some other fields AND a
tblBooked Rooms with a number of fields including RoomID and
BookedDate.

For a given date range, I can generate a vacant room report by
generating a temporary table of all the Rooms and BookedDates using a
cartesian join, and then either deleting the booked rooms, or by
using a 'Not In( )' select query.

Can anyone suggest a solution that does not involve populating a
temporary table?

Peter

.