Sql Table Output

I've been given two tables: Employee and Staff |ID| Name |Surname|Postion| |EmpID|ManID| ---------------------------- ------------- |1 |Scrooge|McDuck |Manage

Solution 1:

SQL:

SELECT Staff.EmpID, Manager.Name AS `Manager Name`, 
       Manager.Position AS `Manager Position`, 
       Employee.Name, Employee.Surname, Employee.Position
FROM (Staff, Employee AS Manager, Employee)
WHERE Manager.ID = Staff.ManID AND
      Employee.ID = Staff.EmpID;

I believe it is now fixed