iankerry
Registered User.
- Local time
- Today, 11:57
- Joined
- Aug 10, 2005
- Messages
- 190
Hi,
hope you can help.
I have two tables: Venues and Events.
The Events table has a field called VenueID which tells me which venue the events will be at.
What I would like is a list of venues that haven't booked for the coming season.
so within a given date period, I would like a list of venues that have no records in the Events table.
Sounds simple, but i have no idea where to start to query for the absence of something!
thanks
ian
hope you can help.
I have two tables: Venues and Events.
The Events table has a field called VenueID which tells me which venue the events will be at.
What I would like is a list of venues that haven't booked for the coming season.
so within a given date period, I would like a list of venues that have no records in the Events table.
Sounds simple, but i have no idea where to start to query for the absence of something!
thanks
ian