Nabonita, You can use this query if you want to see the title:
SELECT issues.issuedate, items.barcode, biblio.title, borrowers.firstname,borrowers.surname, borrowers.cardnumber, borrowers.categorycode FROM issues LEFT JOIN borrowers ON borrowers.borrowernumber = issues.borrowernumber LEFT JOIN items ON issues.itemnumber = items.itemnumber LEFT JOIN biblio ON items.biblionumber=biblio.biblionumber WHERE issues.issuedate = 'yyyy-mm-dd' If you don't need the title, use this query: SELECT issues.issuedate, items.barcode, borrowers.firstname, borrowers.surname, borrowers.cardnumber, borrowers.categorycode FROM issues LEFT JOIN borrowers ON borrowers.borrowernumber = issues.borrowernumber LEFT JOIN items ON issues.itemnumber = items.itemnumber WHERE issues.issuedate = 'yyyy-mm-dd' * * * * Beverly Church LibLime Project Manager phone: 1-888-564-2457 ext. 717 1-301-654-8088 ext. 292 email: bchu...@liblime.com skype: beverlychurch 2011/4/20 nabonita Guha <nabon...@jncasr.ac.in> > Dear Koha users/Developers, > > Can you please help me in building SQL statement to generate current > checkouts on a given date (not for a date range). For example, I need to > generate a report to get list of (barcodes with borrowers card number, > surname and firstname and borrower's category with date of issue) were on > Loan as on 2011-03-29. > > Looking forward to hearing from you. > > With best regards > > Nabonita > > -- > Nabonita Guha > Library-cum-Information Officer > Library, Jawaharlal Nehru Centre > for Advanced Scientific Research, > Jakkur Post, Bangalore 560064 > Karnataka, India > Phone: +91-80-22082930 > Email: nabon...@jncasr.ac.in > Web: http://lib.jncasr.ac.in > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > >
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha