Hello, Previously I received sql help from Heather Braum, regarding generating unique records, that was a big help. Now, I am looking for generating sql report, that is. Background: I am using 2 kind of item types - (1) book and (2) book bank. ( both are used to catalogue only books) "Book"- is used for all library users where as "book bank"- is used for some reserved category of students and respective circulation rules are made. Requirement: Previously provided sql query (by Heather Braum) fetches unique records (non-repeatable) of only one item type. ( that is =a ) But now I wanted to have a report which has to merge item type 1 (book) and item type 2 (book bank) ( that is = a+b) and then look for unique records from this list. Can you please help me how to achieve this for generating a report. Thank You in advance. Satish MV Librarian Govt. Engineering College, Hassan. Karnataka. INDIA. Previous sql: (1) SELECT DISTINCT b.biblionumber, b.title, b.author, t.editionstatement, t.publishercode, t.isbn, count(i.itemnumber) FROM biblio b LEFT JOIN biblioitems t USING(biblionumber) LEFT JOIN items i USING(biblionumber) GROUP BY b.biblionumber (2)
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
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
--