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

You don't specify which two tables were in the original query, that would help a bit.

Are you sure that EMPNO is unique in tAlias2?

Making the assumption that you added tAlias3 it probably is so........

Are you sure that NO is unique in tAlias3? That would explain the duplicate rows since the one record in tAlias1 would match with the multiple records in tAlias3.