Hello community I get the error missing expression when trying to execute this 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(+)
any help please.
