我需要在一个查询中找到所有教师和家长的名字和电子邮件地址
下面是该表的结构：

// Patients Table
ID        guid             parentID     PatientName
1          234               1258      John
2          xyz               111       Paul

// Patient_teacher table
ID          PatiendGuid      teacherid    
1                122            132
2                xyz            1424
3                245            1545
4                xyz            1222

// Members table 
ID                 guid        email                   fname
22                 123        hello@xyz.com            hello
111                xyz        parentEmail@xyz.com      parentName
1424               343        teacherEmail@xyz.com     teacherName
1222               546        teacher2EMail@xyz.com    teacher2Name

下面是所需的结果：

//Required Result

fname        Email
parentName   parentEmail@xyz.com
techerName   teacherEmail@xyz.com
teacher2Name teacher2Email@xyz.com

问题是，当我尝试使用连接进行搜索时，我发现了一个包含parentID和TeacherID的行
下面是我的尝试：

select Members.email,Members.fname
from Members
    join Patients on Members.guid = Patients.guid
    join Patient_Teacher on Patient_Teacher.patientguid = Patients.guid
where patients.guid = 'xyz'