Hi Beverly, Thanks for the SQL statement. This is the output what I was looking for. With 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: nabonita@jncasr.ac.in Web: http://lib.jncasr.ac.in At Thursday, 21-04-2011 on 5:52 pm Church, Beverly wrote: Hi Nabonita, Try this query. It looks for any items that are current checked out where the checkout date was on or before 2011-03-29, or the last renewal date was or before 2011-03-29.. 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 Links: ------ [1] http://lib.jncasr.ac.in/