自行加入以获取员工经理姓名

CREATE VIEW ASSELECt e1.emp_Id EmployeeId, e1.emp_name EmployeeName,        e1.emp_mgr_id ManagerId, e2.emp_name AS ManagerNameFROM   tblEmployeeDetails e1       JOIN tblEmployeeDetails e2       ON e1.emp_mgr_id = e2.emp_id

编辑 ：如果emp_mgr_id为null，则左联接将起作用。

CREATE VIEW AS SELECt e1.emp_Id EmployeeId, e1.emp_name EmployeeName,         e1.emp_mgr_id ManagerId, e2.emp_name AS ManagerName FROM   tblEmployeeDetails e1        LEFT JOIN tblEmployeeDetails e2        ON e1.emp_mgr_id = e2.emp_id