- Article Type: General
- Product: Aleph
- Product Version: 20
We need an SQL query to find reserve bib records that don't have items.
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;
- Article last edited: 10/8/2013