10 Dec
2014
10 Dec
'14
8:13 p.m.
At 12:09 AM 12/11/2014 +0530, SATISH wrote:
[snip] how to achieve for the same tables, for each collection ( as per collection code). Because, at various time intervals, library inspection team here is most interested in knowing how many unique titles and counts as a whole library and also by collection codes.
SELECT DISTINCT b.biblionumber, b.title, b.author, t.editionstatement, t.publishercode, t.isbn, i.ccode, count(i.itemnumber) FROM biblio b LEFT JOIN biblioitems t USING(biblionumber) LEFT JOIN items i USING(biblionumber) WHERE i.ccode=<<Enter collection code>> GROUP BY b.biblionumber; Paul