select e.Ecode, e.Ename , hh.Ecode as Mcode from EQDump e join HRISDetails h on e.Ename = h.Ename join HRISDetails hh on h.managername = hh.ename
select A.EmployeeName,A.Ecode,B.ECode as ManagerECode from HRISDetails as A inner join HRISDetails as B on A.ImmediateSupervisor=B.EmployeeName where A.Ecode in (Select SUBSTRING(ReporteeUserID,4,8) from EQDump)
select EQDump.ECode, EQDump.EName, HRIS2.Ecode as MCode From EQDump inner join HRISDetails HRIS1 on EQDump.ECode = HRIS1.ECode inner join HRISDetails HRIS2 on HRIS1.managername = HRIS2.EName
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)