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