[Koha] SQL Report-Circulation-- Help

[SATISH]

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
>
>
>
>