> SELECT TAlias1.time1,TAlias1.date1,TAlias1.roomno,TAlias1.place1,TAlias2.mobile,TAlias2.tel,TAlias2.empname, TAlias1.discerror,TAlias1.sno,TAlias1.mark1,TAlias1.remark1,TAlias1.remark2 ; > FROM trans1 TAlias1, emp1 TAlias2 ,pasw TAlias3 ; > WHERE Alltrim(UPPER(TAlias3.pasw)) == Alltrim(UPPER(thisform.pageframe1.page1.text2.value)) AND TAlias1.empno = TAlias2.empno ; > AND TAlias1.fexerno=val(ThisForm.pageframe1.page1.text4.value) AND mark1=0 AND TAlias1.fexerno = TAlias3.empno; > ORDER BY date1,sno ; > INTO cursor TAliascursor4 > >>