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