SELECT Series.SeriesID, Series.Series, Max(Book.ReleaseNo) AS MaxOfReleaseNo, Book.Title
FROM Book INNER JOIN Series ON Book.SeriesID=Series.SeriesID
GROUP BY Series.SeriesID, Series.Series, Book.Title;