Hi Pandu Rangaswamy, hope this sql helps your requirements --------------------------------------------------------------------------------------------------------------------------------------------------------------------- SELECT DISTINCT b.biblionumber, b.title, b.author, t.publishercode AS publisher, t.place AS 'place of publication', t.editionstatement AS 'edition', b.copyrightdate AS 'copyright year', i.booksellerid AS 'vendor', i.stocknumber AS 'invoice number', i.price, i.withdrawn AS 'withdrawn stuatus' FROM biblio b LEFT JOIN biblioitems t USING(biblionumber) LEFT JOIN items i USING(biblionumber) GROUP BY b.biblionumber ------------------------------------------------------------------------------------------------------------------------------------------------------------------------ with thanks Satish MV Librarian Govt. Engineering College, Hassan Karnataka
Currently i am using Koha version 3.12.10.000. and i am having two branch libraries.
I am looking in SQL report to generate the books details with the following details.
1. Title of the book 2. Author 3. Publisher 4. Place of Publication and year 5. Name of the vendor 6. Invoice No and Date 7. Price 8. Withdrawn status