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