Hi Venkat, These two SQL reports may be of use to you. Doesn't do exactly what you have asked but close enough for you to modify them to fit your requirement http://wiki.koha-community.org/wiki/SQL_Reports_Library#Bibs_with_specific_k... http://wiki.koha-community.org/wiki/SQL_Reports_Library#List_all_records_wit... On Tue, Jul 7, 2015 at 2:30 PM, venkat narayana Thandu <thanduvenkat@gmail.com> wrote:

Dear Professionals,

Request to provide the SQL report to get the total number of books (not titles) within a subject.

Thanks & Best Regards, T. Venkata Narayana Hyderabad _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

-- Indranil Das Gupta Phone : +91-98300-20971 Blog : http://indradg.randomink.org/blog IRC : indradg on irc://irc.freenode.net Twitter : indradg -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=- Please exchange editable Office documents only in ODF Format. No other format is acceptable. Support Open Standards. For a free editor supporting ODF, please visit LibreOffice - http://www.documentfoundation.org