SELECT TAlias1.sno,TAlias1.fexerno,TAlias1.EMPNO,; TAlias1.date1,TAlias1.place1,TAlias2.empname,TAlias2.empno ; FROM trans1 TAlias1, emp1 TAlias2 ; WHERE TAlias1.empno = TAlias2.empno ; into cursor crsMyCursor readwrite