I'm supposed to write a query for a database that is a little tricky for me. It has an EMPLOYEE table that has these attributes(columns): Emp_Id,Name,Age, Dept_ID, Salary
It also has a DEPARTMENT table that has these attributes(columns): Dep_Id, Dep_Name, Location, Mgr_Id.
I am being asked to list the Employees Names, their Locations and their Manager's Name. The Manager is(of course) an employee Meaning I'm goign to have to select from Name twice. So how can I make a query where I can display both the Name of both the Employee and the manager. I can do one or the other but I have no clue how to do both in the same query.