>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

If you want to use distinct values you may have to go with derived tables.