Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    List of reserve bibs without items

    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Description:
    We need an SQL query to find reserve bib records that don't have items.

    Resolution:
    The following SQL shows 24 non-deleted abc30 doc records which are not linked to any abc50 ADM (or item) record:

    abc30@ALEPH20> select z00_doc_number from z00 minus select substr (Z103_REC_KEY_1,6,9) from z103 where Z103_LKR_LIBRARY = 'ABC50' minus select z13_rec_key from z13 where Z13_TITLE is null;
    ...
    <etc.>


    • Article last edited: 10/8/2013