Beg your pardon I have a numb day.?? what that is mean

anyway i try it no result, it must be,

when i try the last code if i ignore the error i see the result as what i need.

mybe the error only at this line FROM trans1 AS TAlias1;

thanks



>Beg your pardon I have a numb day.
>
>
>>

>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       AS TAlias1;
> INNER JOIN emp1   AS TAlias2;
> ON TAlias1.empno = TAlias2.empno;
> INNER JOIN empdep AS talias3;
> ON TAlias1.fexerno=talias3.empno;
> WHERE TAlias1.fexerno=0;
> ORDER BY date1,sno ;
> NOFILTER;
> INTO CURSOR TAliascursor1
>
>

>
>Agnes