Other than mapping..?

[#1]

Hello Can any one help me with this fix ..?

I have an field Employee and have different rows employee

Emp.ID	empName	ReportsTo	Reports name
1	A	2	?
2	B	3	?
3	C	6	?
4	D	5	?
5	E	1	?
6	F	nil

I want Reportsname based on ReportsTo where ReportsTo are  Emp.ID..without using mapping function..

[luciancotea]

left join (Employee)

Load EmpID as ReportsTo,

         empName as ReportsName

Resident Employee;