SELECT     DISTINCT teacher.teachername, student.studentname, results.grade 
FROM     teacher LEFT JOIN
      (
          student INNER JOIN results 
    ON student.studentname = results.studentname
    AND results.grade = 'A'
      ) 
      ON teacher.teachername = student.teachername