[Koha-devel] Notice question

2010-03-25 Thread Claude Belizaire
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I was asked a question regarding notices that I have trouble understanding. How many notices (Dewey, LCC, etc.) are available per class? Can someone help me figure out what this means and what the appropriate answer would be? Cheers, Claude -BE

Re: [Koha-devel] Custom Reports

2010-03-25 Thread Michael Hafen
Perhaps something like: SELECT br.branchname, b.title, b.author, it.description, i.itemcallnumber, i.barcode, c.description, p.surname, p.firstname FROM issues iss CROSS JOIN branches br USING (branchcode) CROSS JOIN items i USING (itemnumber) CROSS JOIN biblio b USING (biblionumber) CROSS JOIN it