ErrorSource: OraOLEDB, ErrorMsg: ORA-00936: expression absente

master_student — Mon, 27 Jun 2016 12:33:05 GMT

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.

topic ErrorSource: OraOLEDB, ErrorMsg: ORA-00936: expression absente in QlikView