Before the end of 2017 the board will be down for a brief period of time for an upgrade.
Past experience says less than 30 minutes but I can't predict the future.
Also, there is a high probability that the forum will move to a different host, but that will not happen in 2017.

Last issue with title

Discuss using and your tips/tricks for BookCAT
User avatar
Alex Ivanovich
Posts: 287
Joined: Mon Sep 07, 2015 2:24 pm
Location: Russian - Italia

Re: Last issue with title

Postby Alex Ivanovich » Mon May 15, 2017 12:32 pm

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 :|


Return to “Using BookCAT”

Who is online

Users browsing this forum: No registered users and 1 guest