can anyone tell me that right way to do this ??
SELECT tblSchedule.fldDate, tblSchedule.fldSlot, tblSchedule.fldTimes, tblFilms.fldRating, tblFilms.fldReviewURL, tblSchedule.fldAddInfo
FROM tblSchedule
INNER JOIN tblFilms ON tblSchedule.fldSlot=tblFilms.fldTitle
INNER JOIN tblAdditionalInfo ON...