hi,
thank you for reply,

assuming it was your morning ?? no it is 2:20 pm

have a nice time

>Looks like you haven't enough yet coffee this morning, assuming it was your morning :)
>
>>>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