4.DAILY CHECK OUTS

select items.barcode,

biblio.title,

biblio.author,

borrowers.surname,

borrowers.cardnumber

from issues

left join items on items.itemnumber = issues.itemnumber

left join biblio on biblio.biblionumber = items.biblionumber

left join borrowers on borrowers.borrowernumber = issues.borrowernumber

where date(issues.issuedate) >= <<Select Date From|date>> and

date(issues.issuedate) <= <<To|date>>