I'm trying to write a query, with no real luck to find the earliest instance of tblSession.Session_dtmShowing. Everything I try from Min() to simply Group By and Sort By throws errors
SELECT tblFilm.Film_strTitle, tblFilm.Film_dtmOpeningDate, tblSession.Session_dtmShowing
FROM tblFilm INNER JOIN
tblSession ON tblFilm.Film_strCode = tblSession.Film_strCode
The results I'm looking for are
By Title, the opening date, the earliest showing (they can be different as the opening date may not be the same as the showing date
Should be grouped by Title. If there's a way to get the total showings by title that would be useful too.
Any pointers would be appreicated. Thank you