Hi I am doing a college project on VB6 and I am having problems with using an adocontroller to take data from two different tables from a database which are linked together. I have tried this SQL query under the ADO controller recordsource but it dosent seem to work, help please.

SELECT Event.eventID, Event.performers, Event.event_date, Event.start_time, Event.finish_time, Event.genre, Event.VenueID, Venue.venueID, Venue.venue_name, Venue.city, Venue.seat_number
FROM Venue INNER JOIN Event ON Venue.venueID = Event.VenueID
WHERE (([where Venue].[venueID]=[Event].[VenueID]));