select catalog.cat_type_code,catalog.cat_id, catalog.cat_title, catalog.cat_phase_code, catalog.cat_active_yn, TEST_PROFILE.test_pro_status FROM CATALOG INNER JOIN TEST_PROFILE ON TEST_PRO_CAT_ID = CAT_ID where cat_active_yn = 'Y' and test_pro_status = 'L' and cat_type_code in ('PRE', 'T') and cat_sponser_cd = 'DCF'The number of records returned is correct, but the field "cat_phase_code" should have one of two values, either "PH1" or "CWT". In the query results all cat_phase_code fields contain "PH1".