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