Please I am trying to execute the below query and i keep getting the error
ORA-00904: "B"."SUBSTR": invalid identifier
select A.column1,B.SUBSTR(TRAN_REF,11,10),A.column2,B.column1,B.column2
from Table1 A
left join Table2 B
on A.column1= B.SUBSTR(SRC_TRAN_REF,11,10)
>Solution :
The table alias is part of the column, not of the function name:
select A.column1,SUBSTR(B.TRAN_REF,11,10),A.column2,B.column1,B.column2
from Table1 A
left join Table2 B
on A.column1= SUBSTR(B.SRC_TRAN_REF,11,10)