Echec de lecture odbc

[master_student]

Hi,

I get this error : Echec de lecture ODBC whene executing the query bellow :

select trans.*, tab.*

FROM  

RECHARGE_PM.POS_REPORT trans,

RECHARGE_PM.DUMP_RETAILER tab

WHERE  

trans.ACTOR_ID=tab.ACTORE_ID

and trans.REPORT_DATE = TO_DATE (TO_CHAR (SYSDATE - 6, 'DD/MM/YYYY'),'DD/MM/YYYY')

and tab.ACTORE_ID NOT IN ('1114915','1275202','13','4','616484');

Any help please.

Thanks

[syukyo_zhu]

Hi,

I think you get some sames filed from your request because you use tab.* and trans.*