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 browthanks