hi need help with this query,
have a list of times for a booking system
i want a query that lists times that are available for a
certain date.
It needs to look at the bookings table and not display
times that have a booking related to them
tables:
times
timeid time
1 9:00
2 10:00
3 11:00
4 12:00...
bookings
bookid timeid cusid date
1 2 1 28/07/06
2 3 2 28/07/06
3 1 5 29/07/06
4 2 7 29/07/06...
have a list of times for a booking system
i want a query that lists times that are available for a
certain date.
It needs to look at the bookings table and not display
times that have a booking related to them
tables:
times
timeid time
1 9:00
2 10:00
3 11:00
4 12:00...
bookings
bookid timeid cusid date
1 2 1 28/07/06
2 3 2 28/07/06
3 1 5 29/07/06
4 2 7 29/07/06...