iankerry
Registered User.
- Local time
- Today, 10:08
- Joined
- Aug 10, 2005
- Messages
- 190
Hi Guys
I have been trying to work this out using posts from previous queries, but i cant seem to fathom it out.
i have a table called Venues and a table called EventsFlicks.
they are connected by fields Venues.ID and EventsFlicks. VenueID.
What I would like to have is a list of venues that haven't booked any screenings yet. e.g. they will not have an entry in EventsFlicks for the coming period.
Could someone push me in the right direction please?
Many thanks
Ian
I have been trying to work this out using posts from previous queries, but i cant seem to fathom it out.
i have a table called Venues and a table called EventsFlicks.
they are connected by fields Venues.ID and EventsFlicks. VenueID.
What I would like to have is a list of venues that haven't booked any screenings yet. e.g. they will not have an entry in EventsFlicks for the coming period.
Could someone push me in the right direction please?
Many thanks
Ian