Report on Titles in the collection
I want a list of titles having more than one items . Can anyone help me with the SQL query? -- *Regards,* ** *Madhura M.Deodhar* *Librarian *IES Management College and Research Centre VMD Lotlikar Vidya Sankul Opp.Lilavati Hospital, Bandra Reclamation Bandra (West) Mumbai - 50 61378327(direct) 9869385665/9167004647 http://iesmglib.blogspot.com *P **Please consider the environment before printing this e-mail.* * *
Here is the query, what you want :- SELECT items.barcode, biblio.title FROM items LEFT JOIN biblio ON (items.biblionumber=biblio.biblionumber) GROUP BY items.biblionumber HAVING ( COUNT(*) > 1 ) On Mon, Aug 26, 2013 at 7:15 AM, Madhura Deodhar IES Library < library.mcrc@gmail.com> wrote:
I want a list of titles having more than one items . Can anyone help me with the SQL query?
-- *Regards,* ** *Madhura M.Deodhar* *Librarian *IES Management College and Research Centre VMD Lotlikar Vidya Sankul Opp.Lilavati Hospital, Bandra Reclamation Bandra (West) Mumbai - 50 61378327(direct) 9869385665/9167004647
*P **Please consider the environment before printing this e-mail.* * * _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
//BR Sunil
participants (2)
-
Madhura Deodhar IES Library -
sunil sharma