Here is SQL for III ILS to locate item records with no bib records:
-- Locate for item records with no links
-- John Boggs - Sierra Listerv - 2015-09
SELECT
*
FROM
sierra_view.item_view
LEFT JOIN
sierra_view.bib_record_item_record_link ON
item_view.id = bib_record_item_record_link.item_record_id
WHERE
bib_record_item_record_link.item_record_id is NULL
No comments:
Post a Comment