SQL查询从表中查找报告人名称

问题描述

我有一个名为Employee的表，其样本数据如下:

EmpID	EmpName	ReporteeToEmpID	EmpCode
1	Ram	3	ABC111
2	Shyam	3	ABC112

table>

3

karan

4

ABC113

4

Alex

4

ABC114

这里的"ReporteeToEmpID"列指的是Emp向其报告的"EmpID".例如Ram的"ReporteeToEmpId"为3，即Karan EmpID，因此Ram正在向Karan报告.

我需要的结果是:

EmpCode	EmpName	ReportingToEmployeeName
ABC111	Ram	Karan
ABC112	Shyam	karan
ABC113	Karan	Alex
ABC114	Alex	Alex

I have a table called Employee with sample Data as follow:

EmpID	EmpName	ReporteeToEmpID	EmpCode
1	Ram	3	ABC111
2	Shyam	3	ABC112

3

karan

4

ABC113

4

Alex

4

ABC114

Here the Column "ReporteeToEmpID" is referring the "EmpID" to whom the Emp is Reporting to.For example Ram''s "ReporteeToEmpId" is 3 i.e. Karan EmpID so Ram is Reporting to Karan.

I need the Result as :

EmpCode	EmpName	ReportingToEmployeeName
ABC111	Ram	Karan
ABC112	Shyam	karan
ABC113	Karan	Alex
ABC114	Alex	Alex

推荐答案

select A.EmpCode, A.EmpName, B.EmpName as 'Reporting To Employee' from EmpTable as A inner join EmpTable as B on A.ReporteeToEmpID=B.EmpID

希望它能工作..

hope it works..

这篇关于SQL查询从表中查找报告人名称的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！