You are here

Course Reserves Circulation History

Submitted by formerly adam on February 6, 2014

A report for the reserve circulation history of course reserve items. 

 

SELECT RESERVE_ITEM_HISTORY.RESERVE_CHARGES, RESERVE_ITEM_HISTORY.EFFECT_DATE, RESERVE_ITEM_HISTORY.EXPIRE_DATE, BIB_TEXT.TITLE, RESERVE_LIST.LIST_TITLE, RESERVE_LIST.EFFECT_DATE, RESERVE_LIST.EXPIRE_DATE
FROM (RESERVE_ITEM_HISTORY INNER JOIN (RESERVE_LIST INNER JOIN RESERVE_LIST_ITEMS ON RESERVE_LIST.RESERVE_LIST_ID = RESERVE_LIST_ITEMS.RESERVE_LIST_ID) ON RESERVE_ITEM_HISTORY.ITEM_ID = RESERVE_LIST_ITEMS.ITEM_ID) INNER JOIN ((ITEM INNER JOIN MFHD_ITEM ON ITEM.ITEM_ID = MFHD_ITEM.ITEM_ID) INNER JOIN (MFHD_MASTER INNER JOIN (BIB_MFHD INNER JOIN BIB_TEXT ON BIB_MFHD.BIB_ID = BIB_TEXT.BIB_ID) ON MFHD_MASTER.MFHD_ID = BIB_MFHD.MFHD_ID) ON MFHD_ITEM.MFHD_ID = MFHD_MASTER.MFHD_ID) ON RESERVE_LIST_ITEMS.ITEM_ID = ITEM.ITEM_ID;