still same error
>>thank you for reply
>>i try it error Command contains unrecognized phrase/keyword
>
>missplaced some ,
>

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

>
>Agnes