Hi Guys,

The following query is working fine in oracle 7.3 and oracle 8i but not working in 9i. Can you tell me why? The outer joint in SELECT statement is not allowed..thats what 9i complaining but it was fine for 8i.

Thanx in advance
Devang

SELECT C.COUNTER_ID,
C.COUNTER_SUBTYPE_ID,
NVL(CS.PRINT_SEQ(+),0),
NVL(CS.COUNTER_SUBTYPE_DESC(+),
C.COUNTER_ID || ' ' ||
C.COUNTER_SUBTYPE_ID || ' no description'),
NVL(CS.PRINT_FORMAT(+),' '),
SUM(NVL(C.COUNTER_VALUE,0))
FROM COUNTER_DETAIL C,
COUNTER_SUBTYPE CS
WHERE TO_NUMBER(C.COUNTER_OWNER_ID) = 6508
AND C.COUNTER_ID = CS.COUNTER_ID(+)
AND C.COUNTER_SUBTYPE_ID = CS.COUNTER_SUBTYPE_ID(+)
GROUP BY C.COUNTER_ID, C.COUNTER_SUBTYPE_ID, CS.PRINT_SEQ(+),
CS.COUNTER_SUBTYPE_DESC(+), CS.PRINT_FORMAT(+)
ORDER BY CS.PRINT_SEQ(+), C.COUNTER_ID, C.COUNTER_SUBTYPE_ID
/


[Edited by DevangP on 10-03-2002 at 02:43 PM]