static void Fawadd(Args _args) { HcmWorker woker; DirpartyTable DirDepart; HcmPositionDetail pstDetail; HcmPositionWorkerAssignment Assign; HcmPositionDuration pst; DirPartyTable party1; // //pstDetail.VALIDFROM, //pstDetail.VALIDTO, //Assign.VALIDFROM, //Assign.VALIDTO, //party.NAMEALIAS as EmpName, //DirDepart.NAME as DeptName while select * from woker join DirDepart where woker.Person==party1.RecId join Assign where Assign.Worker == woker.RecId join pstDetail where Assign.Position == pstDetail.Position join pst where pst.Position == pstDetail.Position join DirDepart where DirDepart.RecId == pstDetail.Department && woker.PersonnelNumber == '00038' { //--DirDepart.NAME='IT' //--party.NAMEALIAS LIKE '%Muhammad Imran%' info(pstDetail.Description); //return DirDepart.Name } }