title: Trying to find Mentor/mentee pairs that have not submitted a certain report
body: <p>Trying to find the mentor-mentee groups that  have not submitted a specific report (reported = 147). All the pairs have submitted reports but I need the ones who have specifically not submitted 147 yet.</p>
  
  <p>Thanks</p>
  
  <pre><code>SELECT DISTINCT
       e2.Firstname Mentor_FN
      ,e2.lastname Mentor_LN
      ,e1.Firstname Mentee_FN
      ,e1.lastname Mentee_LN
      ,r.ReportID
  FROM
  MentorRelationshipStaging m
  INNER JOIN Employee e1
      ON e1.EmployeeCode = m.MenteeCode
  INNER JOIN Employee e2
      ON e2.EmployeeCode = m.MentorCode
  INNER JOIN UserReport ur1 
      ON ur1.EmployeeID = e2.EmployeeID
  INNER JOIN Report r 
      ON r.reportID = ur1.ReportID
  </code></pre>
  
  <p>DATABASE:<a href="https://imgur.com/a/9JMRpFw" rel="nofollow noreferrer">https://imgur.com/a/9JMRpFw</a></p>