[Solved] how can select all columns and one of them without rebeating [closed]

by


If you want to list the employees and the name of each employee’s department manager, you will need to join the Employee table twice. One way to do this is:

Select Employees.*
   , Departments.*
   , Managers.EmployeeName as ManagerName
From Employees
Inner Join Departments on departments.DeptID = employees.DeptID
Inner Join Employees managers on managers.EmpId = departments.ManagerID

3

solved how can select all columns and one of them without rebeating [closed]