Question

You maintain an Employee table in a Fabric warehouse with columns EmployeeID, EmployeeName, and ManagerID (where ManagerID references another row's EmployeeID). A report author needs a single flat result set that lists each employee's name alongside their direct manager's name on the same row, including employees who have no manager. Which single SQL technique should you use to produce this result most directly?

Accepted Answer

A LEFT JOIN of the Employee table to itself, matching e.ManagerID to m.EmployeeID

Answer

A recursive common table expression that walks the entire reporting hierarchy

Answer

An INNER JOIN of the Employee table to itself, matching e.ManagerID to m.EmployeeID

Answer

A CROSS JOIN between two copies of the Employee table