SELECT idty.lookup_code industry_code_type, idty.Meaning industry_code_type_meaning, idty.Description industry_code_type_desc FROM AR_LOOKUPS IDTY WHERE idty.lookup_type = 'SIC_CODE_TYPE' and exists (select 1 from ar_lookups idtc where idtc.lookup_type = idty.lookup_code)
SELECT IDTY.LOOKUP_CODE INDUSTRY_CODE_TYPE
, IDTY.MEANING INDUSTRY_CODE_TYPE_MEANING
, IDTY.DESCRIPTION INDUSTRY_CODE_TYPE_DESC
FROM AR_LOOKUPS IDTY
WHERE IDTY.LOOKUP_TYPE = 'SIC_CODE_TYPE'
AND EXISTS (SELECT 1
FROM AR_LOOKUPS IDTC
WHERE IDTC.LOOKUP_TYPE = IDTY.LOOKUP_CODE)
|
|
|