Page 3 of 3

Re: Last issue with title

Posted: Mon May 15, 2017 12:32 pm
by Alex Ivanovich
DougWilliams wrote:I am not at a computer where I can test it, but try this.

Code: Select all

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;

anything, does not work :(
In fact, with this query returns the wrong results :(

Something wrong in the "code .xslt" or "query"v :|

:(