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

    How can I find course reserve bib records with no items?

    1. Last updated
    2. Save as PDF
    • Article Type: General
    • Product: Aleph
    • Product Version: 16.02

    Description:
    Can you tell me an sql query or some other way to find course reserve bib records with no items?

    Resolution:
    SQL-ABC30> select substr (Z103_REC_KEY,6,9) from z103 where substr (Z103_REC_KEY,1,15) not in (select substr (Z103_REC_KEY,1,15) from z103 where Z103_REC_KEY_1 like 'ABC50%');

    • Article last edited: 10/8/2013