MySQL SELF JOINS are ... ughhh

Skip ad
79 Views

  • Thanks! Share it with your friends!

    You disliked this video. Thanks for the feedback!

brocode
Published
#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;
Category
Bro Code
Tags
MySQL tutorial for beginners, SQL tutorial for beginners, MySQL course
Be the first to comment