Hi, I want to convert this checked in sql report into renew sql report. How i can convert this report. guide me. SELECT b.title, b.author, i.itemcallnumber, i.barcode, c.returndate FROM (SELECT iss.returndate, iss.itemnumber FROM issues iss, (SELECT @StartDate:=<<Between (yyyy-mm-dd)|date>>,@EndDate:=<<and (yyyy-mm-dd)|date>>) AS var WHERE date(iss.returndate) BETWEEN @StartDate AND @EndDate UNION ALL SELECT oi.returndate, oi.itemnumber FROM old_issues oi WHERE date(oi.returndate) BETWEEN @StartDate AND @EndDate) AS c LEFT JOIN items i USING (itemnumber) LEFT JOIN biblio b USING (biblionumber) WHERE i.homebranch=<<Item belongs TO|branches>> -- *Muhammad Arshad Iqbal* Assistant Librarian at Publishing and Student Affairs Directorate, National University of Science and Technology (NUST) Islamabad.