worker bee (11/14/2012)

---

I updated with no results that are different. I still get two rows, 26 is the TAXABLE, TAX-DEF and the other is 27 SOLE, JOINT, OTHER. I had tried this before. Here is the query and the results;

select distinct

CASE aor.optional_category_cd

WHEN '26' THEN aoc.optional_class_nm

END AS AccountType,

CASE aor.optional_category_cd

WHEN '27' THEN aoc.optional_class_nm

END AS AccountType

from

ACCOUNT_OPT_REF aor inner join ACCOUNT_OPT_CLASS aoc ON aor.Optional_Category_Cd = aoc.Optional_Category_Cd and

aor.Optional_Class_Cd = aoc.Optional_Class_Cd

where

aor.Optional_Class_Cd > 1

AccountType AccountType

TAXABLE NULL

NULL SOLE

TAX-DEFERRED/NOT TAX ON WDRAWL NULL

NULL JOINT

TAX-DEFERRED & TAX ON WDRAWL NULL

NULL OTHER

NULL NULL