Mohammed,

would

SELECT trans1
*brow

SELECT;
 TAlias1.time1, TAlias1.date1,;
 TAlias1.roomno, TAlias1.place1,;
 TAlias2.mobile, TAlias2.tel,;
 TAlias2.empname, TAlias1.discerror,;
 TAlias1.sno, TAlias1.mark1,;
 talias3.empname;
 FROM trans1       ALIAS TAlias1,;
 INNER JOIN emp1   ALIAS TAlias2,;
 ON TAlias1.empno = TAlias2.empno;
 INNER JOIN empdep ALIAS talias3 ;
 ON TAlias1.fexerno=talias3.empno;
 WHERE TAlias1.fexerno=0;
 ORDER BY date1,sno ;
 NOFILTER;
 INTO CURSOR TAliascursor1

BROW

work for you?

Agnes
>hi all,
>
>i need your help to fix this code under,
>(incloude TAlias1.fexerno=0 )
>
>

>If Not Used('trans1')
>    USE trans1.dbf Alias trans1 Again In 0 Shared
>Endif
>
>SELECT trans1
>*brow
>
>      SELECT  TAlias1.time1,TAlias1.date1,TAlias1.roomno,TAlias1.place1,TAlias2.mobile,TAlias2.tel,;
>      TAlias2.empname, TAlias1.discerror,TAlias1.sno,TAlias1.mark1,TAlias3.empname ;
>        FROM trans1 TAlias1, emp1 TAlias2, empdep talias3 ;
>       WHERE  TAlias1.empno = TAlias2.empno   ;
>          and TAlias1.fexerno=TAlias3.empno ;&&and TAlias1.fexerno=0
>    ORDER BY date1,sno ;
>    nofilter;
>        INTO cursor TAliascursor1
>        brow
>
>

>
>thanks