我如何self join
一个表来显示由任一Blake or Jones
管理的人员的姓名、员工编号和经理姓名?
我正试图以以下方式排列:
SELECT
FROM
INNER JOIN
ON
WHERE
我遇到的问题是,到目前为止,我已经很好地理解了MySQL
,而且我似乎无法理解表连接本身的概念。。。。任何帮助都将不胜感激。提前感谢
MySQL自联接,使用联接将表联接到自身
SELECT *
FROM table1 AS t1
INNER JOIN table1 AS t2
ON t1.col_name=t2.col_name
WHERE t1.col_name='xyz'
select t1.name,t1.employee_number,t1.manager_name from table t1 join
table t2 where t1.manager_name = t2. manager_name and t2.manager_name in
('Blake','Jones');