Hi Both of you and thanks for the replies.
I think I should have explained what result I want.
The end result I was after was as if you had clicked the column headers in that order:
Title then Series
This way the result (if you had one author in the DB) would show all non-series books in alphabetical order, but any book in a series would then be in series order.
Following on, if there were 2 different authors, the previous sort would occur with the additional sort of authors.
I hope that's clearer.
Thanks again.
|