• Article Type: General
• Product: Aleph
• Product Version: 17.01

Description:
I'm using z00r. I'm looking for all the serials that have a particular 049.

Separate queries work well

select z00r_doc_number from z00r where Z00R_FIELD_CODE = 'FMT' and Z00R_TEXT = 'SE';

select z00r_doc_number from z00r where Z00R_FIELD_CODE = '049' and z00r_text like '%ILUU%';

But when I try to combine them into one query, I 'm not getting any hits. I tried

select z00r_doc_number from z00r where (Z00R_FIELD_CODE = 'FMT' and Z00R_TEXT = 'SE') and (Z00R_FIELD_CODE = '049' and z00r_text like '%ILUU%');

Resolution:
In the z00r, each field is a separate record. You would need to do this:

SQL> select z00r_doc_number from z00r where z00r_doc_number in (select z00r_doc_number from z00r where Z00R_FIELD_CODE = 'FMT' and Z00R_TEXT = 'SE' ) and z00r_doc_number in (select z00r_doc_number from z00r where Z00R_FIELD_CODE = '049' and z00r_text like '%ILUU%' );