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 <nicolas.legr...@bulac.fr> wrote: > something like this? > > SELECT DISTINCT isbn FROM biblioitems ; > > cheers, > > > 2014-02-25 8:23 GMT+01:00 Kerrie Stevens <kstev...@harvest.edu.au>: > >> 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 >> Koha@lists.katipo.co.nz >> 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 > Koha@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha