MySQL SELF JOINS are ... ughhh

#MySQL #tutorial #course
00:00:00 example 1
00:05:44 example 2
00:00:00 conclusion
SELECT a.first_name, a.last_name,
CONCAT(b.first_name," ", b.last_name) AS "reports_to"
FROM employees AS a
INNER JOIN employees AS b
ON a.supervisor_id = b.employee_id;