Can I select the same column twice?

Question

I want to select the names of employees vs the names of their supervisors.
Where each employee hava a field for his supervisor's id and
the supervisors themselves are also employees in the employees table.
How can i do that?

Answer 1

try this, change the column/tables name to match your column/tables

SELECT employees.name, supervisors.name
FROM employees
INNER JOIN employees ON employees.superId = supervisors.id