Custom Reports: Query Reports All Bib Records That Contain an 856 Field

[This article was copied from the Voyager Wiki.]

This query will report back on all bib records that contain an 856.

SELECT BIB_TEXT.TITLE, ELINK_INDEX.LINK_TEXT, ELINK_INDEX.LINK, BIB_TEXT.BIB_ID, ELINK_INDEX.RECORD_TYPE
FROM ELINK_INDEX INNER JOIN BIB_TEXT ON ELINK_INDEX.RECORD_ID =
BIB_TEXT.BIB_ID
GROUP BY BIB_TEXT.TITLE, ELINK_INDEX.LINK_TEXT, ELINK_INDEX.LINK, BIB_TEXT.BIB_ID, ELINK_INDEX.RECORD_TYPE
HAVING (((ELINK_INDEX.RECORD_TYPE)="B"))
ORDER BY BIB_TEXT.TITLE;