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 <egpetridis@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.legrand@bulac.fr> wrote:
something like this?
SELECT DISTINCT isbn FROM biblioitems ;
cheers,
2014-02-25 8:23 GMT+01:00 Kerrie Stevens <KStevens@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