Re: select * from (select * from bob) and other easy stuff

Why the long decode statement shouldn't this be in a small conversion table? e_type_code | case_type 12A | 265101 etc. Also, why use the select * from (select * from <table>) construct it seems like a simple select could take its place unless I am missing something. > internetuser > select > et_code,et_desc,case_type as ct_code,valid_case_type_desc_txt as > ct_desc > from notrust.valid_case_type vct, > (select e_type_code as ET_CODE,e_type_desc_txt as ET_DESC, > decode (e_type_code,'12A','265101','12B','265102','12C','265200', > 'IL-SS','265202','POOL','265204','12CH8','265208','IL-S','265211','14H1', > '265301','14H2','265302','14H3','265303','14H5','265306','14H8','265308', > '14H6','265311','UGRT','262720','CGNF','262712','CGPD','262711','MH','262710', > 'SCHL','262714','GPGT','262730','TNCGT','262713') as case_type > from notrust.e_type) acs > where acs.case_type = vct.valid_case_type_code and case_type is not null