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