Mohammed,

I can hardly work on guesses
You need to describe your problem
What's wrong?
-Error
What error?

-Wrong result set
You need to specify what is a duplicate record (for example: all fields are identic, some fields need to be identic)
Is there something like a PK and what is the PK?

Agnes

>thank you for reply,
>itry it but same result,
>
>>Mohammed
>>
>>you need to specify the joins and there conditions ()
>>Try
>>

>>SELECT;
>> TAlias1.time1,;
>> TAlias1.date1,;
>> TAlias1.roomno,;
>> TAlias1.place1,;
>> TAlias2.mobile,;
>> TAlias2.tel,;
>> TAlias2.empname,;
>> TAlias1.discerror,;
>> TAlias1.sno,talias3.des ;
>> FROM trans1 TAlias1;
>> INNER JOIN emp1 TAlias2;
>> ON TAlias1.empno = TAlias2.empno;
>> INNER JOIN errtyp talias3 ;
>> ON TAlias1.prono=talias3.no;
>> WHERE  TAlias1.fexerno==0 ;
>> ORDER BY date1,sno ;
>> INTO CURSOR crsMyCursor READWRITE
>>

>>
>>Agnes
>>>hi all,
>>>
>>>i try this code at grid display duplicate records,
>>>
>>>but via 2 tables it is ok,
>>>
>>>any help.
>>>
>>>

>>>SELECT  TAlias1.time1,TAlias1.date1,TAlias1.roomno,TAlias1.place1,TAlias2.mobile,TAlias2.tel,TAlias2.empname, TAlias1.discerror,TAlias1.sno,talias3.des ;
>>>   FROM trans1 TAlias1, emp1 TAlias2 , errtyp TAlias3 ;
>>>   WHERE  TAlias1.empno = TAlias2.empno and TAlias1.prono=TAlias3.no    ;
>>>   AND TAlias1.fexerno==0 ;
>>>   ORDER BY date1,sno ;
>>>   into cursor crsMyCursor readwrite
>>>
>>>