Thanks a lot. Its working. Vikram Zadgaonkar
On Tue, Jun 3, 2014 at 6:04 PM, Katelyn Browne <kbro...@ccpcs.org> wrote: > 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