thank you for reply
i try it error Command contains unrecognized phrase/keyword

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 ,;&&Command contains unrecognized phrase/keyword
 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

>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