Navigation

9/10/2015

SQL to locate item records with no bib records


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