We don't really use "in transit," but I think this should do what you want:
SELECT bt.itemnumber, b.title, i.itemcallnumber, i.barcode, bt.datesent, bt.frombranch, bt.tobranch FROM branchtransfers bt LEFT JOIN items i USING (itemnumber) LEFT JOIN biblio b USING (biblionumber) WHERE bt.datearrived IS NULL Katelyn Browne Middle/High School Librarian Capital City Public Charter School 100 Peabody Street NW Washington, DC 20011 (202) 387-0309 x1745 kbro...@ccpcs.org http://www.ccpcs.org/library/ On Tue, Jun 3, 2014 at 5:59 AM, vikram zadgaonkar < vikramczadgaon...@gmail.com> wrote: > Hi, > I am looking for a report for all items which are in transit. > Thanks in advance. > Vikram Zadgaonkar > _______________________________________________ > 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