>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