hi,
no errors
i see at the grid, records twice ex.. if record no is 1 i see 2 records with same no 1,1 and another fields
no time1..........
1 12:34
1 12:34
2 ....
2 .....
.
.
just when i append table3,

with 2 tables i see one record only this what i want to display

thank you
>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
>>>>
>>>>