Hi everyone, I get this error message :
ErrorSource: OraOLEDB, ErrorMsg: ORA-00936: expression absente
Here 's my query:
select tt.*, d.aliasname cl2
from (
SELECT
REPORT_TYPE,
REPORT_DATE,
DEBITED_ACTOR_ID,
CREDIT_ACTOR_ID,
credit,
tab.ALIASNAME cl1
FROM POS_REPORT_FINAL_1904 trans , DUMP_RETAILER_FINAL tab
WHERE
trans.debited_ACTOR_ID =tab.ACTORE_ID(+)
and report_type = 'TSR001'
AND function_id = 243
and debited_actor_id IN ()
AND OPER_STATE = 61
AND IERRORX = 0) tt, DUMP_RETAILER_FINAL d
where
tt.credit_ACTOR_ID =d.ACTORE_ID(+)
Could you assist me please
