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