ORA-01417: a table may be outer joined to at most one other table
6195Aug 31 2007 — edited Sep 3 2007Hi,
Any Idea how o fix it ? Here is the query , I am trying to connect Accounting_Base_Group table
SELECT COST_CATEGORY.CODE_NAME COST_CATEGORY,
COST_CATEGORY.CODE_NAME||' '||COST_CATEGORY_ITEM.CODE_NAME CATEGORY_ITEM, COST_ELEMENT.CODE_VALUE COST_ELEMENT_CODE,
COST_ELEMENT.CODE_NAME COST_ELEMENTS,
( SELECT 1 FROM ACCOUNTING_BASE_GROUP ABJS
WHERE ABJS.COST_ELEMENT_ID = COST_ELEMENT.CODE_ID
AND ABJS.COST_ELEMENT_CAT_ITEM_ID = COST_CATEGORY_ITEM.CODE_ID) CROSS_DATA
FROM CODES COST_CATEGORY, CODE_TYPES CATEGORY,
CODES COST_ELEMENT , CODE_TYPES COST_ELEMENT_CATEGORY,
CODES COST_CATEGORY_ITEM, CODE_TYPES ITEM_TYPE,
ACCOUNTING_BASE_GROUP ABJ
WHERE COST_CATEGORY.CODE_TYPE = CATEGORY.CODE_TYPE_ID
AND CATEGORY.CODE_TYPE_NAME = 'COST_ELEMENT_CATEGORY_CODE'
AND COST_ELEMENT.CODE_TYPE = COST_ELEMENT_CATEGORY.CODE_TYPE_ID
AND COST_ELEMENT_CATEGORY.CODE_TYPE_NAME = 'COST_ELEMENT_CODE'
AND COST_CATEGORY_ITEM.CODE_PARENT_ID = COST_CATEGORY.CODE_ID
AND COST_CATEGORY_ITEM.CODE_TYPE = ITEM_TYPE.CODE_TYPE_ID
AND ITEM_TYPE.CODE_TYPE_NAME = COST_ELEMENT_CATEGORY_ITEM_CODE'
AND ABJ.COST_ELEMENT_ID(+) = COST_ELEMENT.CODE_ID
AND ABJ.COST_ELEMENT_CAT_ITEM_ID(+) = COST_CATEGORY_ITEM.CODE_ID
Thanks