Hi,

This is the query i am trying to build

I have attached the same in the file....


while running its throwing an error ........

NVL((SELECT USAGEMODE FROM KKTYPEMAST_AP B WHERE B.TYPE_ID_USG=A .TYPE_ID_USG AND
B.JURISDICTION= A.JURISDICTION) ,(SELECT USAGEMODE FROM KKTYPEMAST_AP B WHERE B.T
YPE_ID_USG=A.TY PE_ID_USG AND ROWNUM=1)),
*
ERROR at line 15:...