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_keyword_in_subjects http://wiki.koha-community.org/wiki/SQL_Reports_Library#List_all_records_with_at_least_one_subject On Tue, Jul 7, 2015 at 2:30 PM, venkat narayana Thandu <[email protected]> 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 > [email protected] > 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 _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
