• 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