I am trying to write an SQL statement using INNER JOIN to retrieve data from 3 different tables.
This is what I have:
SELECT * FROM tbl_WhatsOn INNER JOIN tbl_Theatres ON tbl_WhatsOn.WhatsOnVenue = tbl_Theatres.TheatresID WHERE WhatsOnCity = " + Replace(rs_WhatsOnByCity__MMColParam, "'", "''" + " ORDER BY Date ASC
It works great, but I need to reference two other tables to display the foreign key fields from tbl_WhatsOn, namely tbl_City and tbl_Province.
Any suggestions?