It prints a value only once, if you want all values from all rows, remove the 'DISTINCT' from the request.
2014-02-26 0:54 GMT+01:00 Manos PETRIDIS <egpetri...@gmail.com>: > 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 > -- *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
