SELECT CODS.MEANING NAME, CODS.LOOKUP_CODE CODE, CODS.LOOKUP_TYPE TYPE FROM AR_LOOKUPS CODS,AR_LOOKUPS TYPS WHERE TYPS.LOOKUP_TYPE = 'SIC_CODE_TYPE' AND CODS.LOOKUP_TYPE = TYPS.LOOKUP_CODE
View Text - HTML Formatted
SELECT CODS.MEANING NAME , CODS.LOOKUP_CODE CODE , CODS.LOOKUP_TYPE TYPE FROM AR_LOOKUPS CODS , AR_LOOKUPS TYPS WHERE TYPS.LOOKUP_TYPE = 'SIC_CODE_TYPE' AND CODS.LOOKUP_TYPE = TYPS.LOOKUP_CODE