Hi all, I wrote this report to get all subject headings in a Koha system that start with key phrases:
SELECT lcsh FROM (SELECT biblionumber, ExtractValue(marcxml,'//datafield[@tag="610"]/subfield[@code>="a"]') AS lcsh FROM biblioitems) AS subjects WHERE lcsh LIKE "College%" OR lcsh LIKE "Seminary%" GROUP BY lcsh What's happening is if there is more than one 610 on a bib record it's showing them both on one line. I tried using DISTINCT, but that's didn't do the trick, so I'm up for ideas. Nicole _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha