Thanks for the reply Luis, I'm getting closer. Currently I have:

SELECT Distinct(Projects)

FROM Projects

LEFT JOIN ProjTime

ON Projects.Group=ProjTime.Group;

This shows all the Projects. How would I change the On Clause to grab all the Projects within Group ABC in the projects table along with the corresponding Group (ABC also) in ProjTime in the month of June?