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.m...@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 > > http://iesmglib.blogspot.com > > *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 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha