mysql - 从连接中具有多个 id 的一张表中获取名称

Question

员工

ID    Name   
1     John
2     Williams

预约

ID  DoctorName   Employee_id  Team lead
1    willson          1            2

SQL

SELECT E.*,A.* FROM Employee as E,Appointment as A WHERE A.Employee_id = E.ID

这是我的加入，如果我想要获取团队领导姓名我们该如何做到这一点？

Answer 1

试试这个

SELECT E.name
FROM Employee E
JOIN Appointment A 
ON A.Employee_id = E.ID
WHERE [some condition here]