hi,
check your ON clause, see what it will result.? how

thank you

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

>Mohammed,
>
>check your ON clause, see what it will result.
>
>AFK
>Agnes
>>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,