thank you,it works
>>thank you for reply,
>>i see, but i need another empname from another table(Talias4.empdep),
>>
>>the field name it can be as empnamew
>>
>>
>See change inside. Does it solve your problem?
>
>
>

>SELECT;
> TAlias1.time1,;
> TAlias1.date1,;
> TAlias1.roomno,;
> TAlias1.place1,;
> TAlias2.mobile,;
> TAlias2.tel,;
> TAlias2.empname,;
> TAlias1.discerror,;
> TAlias1.sno,TAlias1.fexerno,talias3.des, TAlis4.EmpName as empnamew ;
> FROM trans1 as TAlias1 ;
> INNER JOIN emp1 as TAlias2 ;
> ON TAlias1.empno = TAlias2.empno ;
>INNER JOIN errtyp AS TAlias3 ; 
> ON TAlias1.proplemno=talias3.flag;
>INNER JOIN DepName AS TAlias4 ;
>ON Talias1.fexerno=Talias4.empno ;
> WHERE  TAlias1.fexerno>=0  AND TAlias1.mark1=0;
> ORDER BY TAlias1.date1,TAlias1.sno ;
> INTO CURSOR crsMyCursor READWRITE