SELECT; TAlias1.time1,; TAlias1.date1,; TAlias1.roomno,; TAlias1.place1,; TAlias2.mobile,; TAlias2.tel,; TAlias2.empname,; TAlias1.discerror,; TAlias1.sno,talias3.des ; FROM trans1 TAlias1; INNER JOIN emp1 TAlias2; ON TAlias1.empno = TAlias2.empno; INNER JOIN errtyp talias3 ; ON TAlias1.prono=talias3.no; WHERE TAlias1.fexerno==0 ; ORDER BY date1,sno ; INTO CURSOR crsMyCursor READWRITEAgnes
>SELECT TAlias1.time1,TAlias1.date1,TAlias1.roomno,TAlias1.place1,TAlias2.mobile,TAlias2.tel,TAlias2.empname, TAlias1.discerror,TAlias1.sno,talias3.des ; > FROM trans1 TAlias1, emp1 TAlias2 , errtyp TAlias3 ; > WHERE TAlias1.empno = TAlias2.empno and TAlias1.prono=TAlias3.no ; > AND TAlias1.fexerno==0 ; > ORDER BY date1,sno ; > into cursor crsMyCursor readwrite > >