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 tblSchedule.fldAddInfo=tblAdditionalInfo.fldTitle
WHERE fldDate>=Date()
ORDER BY fldDate;
when i try to save this i get a syntax error.
"missing operator in query expression 'tblSchedule.fldSlot=tblFilms.fldTitle
INNER JOIN tblAdditionalInfo ON tblSchedule.fldAddInfo=tblAdditionalInfo.fldTitle' "
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 tblSchedule.fldAddInfo=tblAdditionalInfo.fldTitle
WHERE fldDate>=Date()
ORDER BY fldDate;
when i try to save this i get a syntax error.
"missing operator in query expression 'tblSchedule.fldSlot=tblFilms.fldTitle
INNER JOIN tblAdditionalInfo ON tblSchedule.fldAddInfo=tblAdditionalInfo.fldTitle' "