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

Last updated
Save as PDF
Share
1. Share
2. Tweet
3. Share

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