SELECT chv.dim_hierarchy_id, chv.value_id, chv.parent_value_id, crc.name, crc2.name FROM CN_HIERARCHY_EDGES CHV,CN_REVENUE_CLASSES CRC,CN_REVENUE_CLASSES CRC2 where chv.value_id = crc.revenue_class_id and chv.parent_value_id = crc2.revenue_class_id
SELECT CHV.DIM_HIERARCHY_ID
, CHV.VALUE_ID
, CHV.PARENT_VALUE_ID
, CRC.NAME
, CRC2.NAME
FROM CN_HIERARCHY_EDGES CHV
, CN_REVENUE_CLASSES CRC
, CN_REVENUE_CLASSES CRC2
WHERE CHV.VALUE_ID = CRC.REVENUE_CLASS_ID
AND CHV.PARENT_VALUE_ID = CRC2.REVENUE_CLASS_ID
|
|
|