Answered by:

SQL Query challenge in Microsoft Access 2013

Question

Have an urgent query to produce in MICROSOFT ACCESS 2013 before a crucial exec review tomorrow. Appreciate your help in advance. Essentially, I have two tables that are sourced by SharePoint lists that I need to produce a JOIN query with.
Here's the configuration.

TABLE1 is named "TEACHERS". Its fields are:
Field 1: ID (AutoNumber)
Field 2: NAME (Short Text)
Field 3 EMAIL (Short Text)
Field 4: PHONE (Short Text)