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 > > > > _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
