MySQL SELF JOINS are ... ughhh

MySQL SELF JOINS are ... ughhh

Bro Code

55 лет назад

78,449 Просмотров

#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;

Тэги:

#MySQL_tutorial_for_beginners #SQL_tutorial_for_beginners #MySQL_course #SQL_course
Ссылки и html тэги не поддерживаются


Комментарии: