thank you for reply,
i see, but i need another empname from another table(Talias4.empdep),

the field name it can be as empnamew

thanks
>>hi all,
>>
>>i need to add another table at this code as
>>
>>Talias4.empname
>>
>>depname as Talias4
>>
>>add to where (and Talias1.fexerno=Talias4.empno)
>>

>>If Not Used('trans1')
>>    USE trans1.dbf Alias trans1 Again In 0 Shared
>>Endif
>>
>>thanks
>
><pre>
>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 EmpName1 ;
> 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

>
>We do have another EmpName in this select already.