Thanks a lot. Its working. Vikram Zadgaonkar On Tue, Jun 3, 2014 at 6:04 PM, Katelyn Browne <kbrowne@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 kbrowne@ccpcs.org http://www.ccpcs.org/library/
On Tue, Jun 3, 2014 at 5:59 AM, vikram zadgaonkar < vikramczadgaonkar@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