Thursday, October 16, 2014

MySQL, find those values not in another table




In MySQl, Find those emplid in courses_offered_has_stakeholders table, but not in stakeholders table
      SELECT DISTINCT table1.emplid
      FROM courses_offered_has_stakeholders as table1 LEFT JOIN stakeholders as table2 ON          

      table2.emplid=table1.emplid
      WHERE table2.emplid IS NULL;"

No comments:

Post a Comment