Pages

All Checked Out Books in Koha

SELECT c.date_due, p.surname, p.firstname,
       p.phone, p.email, b.title, b.author,
       i.itemcallnumber, i.barcode, i.location 
FROM issues c
LEFT JOIN items i ON (c.itemnumber=i.itemnumber) 
LEFT JOIN borrowers p ON (c.borrowernumber=p.borrowernumber) 
LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber) 
ORDER BY c.date_due ASC
 

Source :  
http://wiki.koha-community.org/wiki/SQL_Reports_Library#All_Checked_Out_Books

Free computer science, programming and IT books..

Free computer science, programming and IT books will keep you up to date on programming and core issues within computer and information technology. You can download IT textbooks about programming using Java, Prolog techniques , Microsoft Office skills!
Read more