>>If Not Used('trans1') >> USE trans1.dbf Alias trans1 Again In 0 Shared >>Endif >> >>thanks > ><pre> >SELECT; > TAlias1.time1,; > TAlias1.date1,; > TAlias1.roomno,; > TAlias1.place1,; > TAlias2.mobile,; > TAlias2.tel,; > TAlias2.empname,; > TAlias1.discerror,; > TAlias1.sno,TAlias1.fexerno,talias3.des, TAlis4.EmpName as EmpName1 ; > FROM trans1 as TAlias1 ; > INNER JOIN emp1 as TAlias2 ; > ON TAlias1.empno = TAlias2.empno ; >INNER JOIN errtyp AS TAlias3 ; > ON TAlias1.proplemno=talias3.flag; >INNER JOIN DepName AS TAlias4 ; >ON Talias1.fexerno=Talias4.empno ; > WHERE TAlias1.fexerno>=0 AND TAlias1.mark1=0; > ORDER BY TAlias1.date1,TAlias1.sno ; > INTO CURSOR crsMyCursor READWRITE>