Listing dates that don't exist, schedule listing.

[Stuart Corbishley]

I want to generate a table of available timeslots for a booking system, the timeslots are set in a table, and the current bookings are in a bookings table.

I basically would like an output like this

|--------|----------------|-------------|
| Date | Timeslot | Booking_ID |
|--------|----------------|-------------|
| 16/4/08| 8:30 | null |
| 16/4/08| 12:30 | null |
| 16/4/08| 15:30 | 56 |
| 17/4/08| 8:30 | null |
| 17/4/08| 12:30 | null |
| 17/4/08| 15:30 | 45 |
|--------|----------------|-------------|

So if the date doesn't match up it still puts it out...
My intent is to generate a schedule for a whole week, by specifying the start date... it would fetch the timeslots available, and then generate a list of timeslots for each day in that week, and only if there is a booking matching that combination, then return the booking_id that relates.

I've been playing with IN statements and BETWEEN, and a few others, it's really confusing me, especially generating a list of dates that don't specifically exist.

Any help would be REALLY appreciated!