Custom Reports: Query for Bibliographic Records without MFHD
Created By: Shelley Schultz
Created on: 5/15/2019
[This article was copied from the Voyager Wiki.]
The [query below] will gather all bib records that do not have a MFHD attached. I run this on a monthly basis.
SELECT BIB_TEXT.BIB_ID, BIB_TEXT.TITLE, BIB_MASTER.SUPPRESS_IN_OPAC
FROM (BIB_TEXT LEFT JOIN BIB_MFHD ON BIB_TEXT.BIB_ID = BIB_MFHD.BIB_ID) INNER JOIN BIB_MASTER ON BIB_TEXT.BIB_ID = BIB_MASTER.BIB_ID
WHERE (((BIB_MFHD.MFHD_ID) Is Null))
ORDER BY BIB_TEXT.TITLE;