Could it be that the select against biblioitems miss multiple/alternative ISBN entries for a single item?
Sent from my iPhone On 25 Φεβ 2014, at 2:40 μ.μ., Nicolas Legrand <[email protected]> wrote: > something like this? > > SELECT DISTINCT isbn FROM biblioitems ; > > cheers, > > > 2014-02-25 8:23 GMT+01:00 Kerrie Stevens <[email protected]>: > >> I've searched through the reports site but can't find anything that sounds >> like it will do what I want. >> It's a simple report, but I just can't work it out... any help would be >> very much appreciated. >> I need a report to list every ISBN in my collection - a simple but very >> long results list. >> >> Does anyone have any suggestions of how to put it into SQL? >> Thank you for your help, >> Kerrie >> >> _______________________________________________ >> Koha mailing list http://koha-community.org >> [email protected] >> http://lists.katipo.co.nz/mailman/listinfo/koha > > > > -- > > *Nicolas Legrand* > Administration technique et développements du système de gestion de la > bibliothèque > > [image: Logo BULAC] > > Bibliothèque universitaire > des langues et civilisations > > 65 rue des Grands Moulins > F-75013 PARIS > T +33 1 81 69 *18 22* > www.bulac.fr > _______________________________________________ > Koha mailing list http://koha-community.org > [email protected] > http://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha

