I'm really stuck here. I can't figure out how to add this table into this query.

I am trying to add in the Titles table shown here:
http://maroisconsulting.com/temp/query.png

This is my query so far:

SELECT d.GroupId, Sum(d.cert_complete) AS SumOfcert_complete, Count(d.cert_complete) AS CountOfcert_complete
FROM (SELECT DISTINCT s.GroupId, e.EmployeeID, IIf(e.Certified Is Null,0,1) AS cert_complete FROM (Stores AS s INNER JOIN EmployeeStores AS es ON s.StoreId=es.StoreId) INNER JOIN Employees AS e ON es.EmployeeId=e.EmployeeID)  AS d INNER JOIN Groups ON d.GroupId = Groups.GroupId
GROUP BY d.GroupId;

Once it's in, I'm going to add

WHERE Titles.IsManager

Problem is, I don'tm understand this goofy sql syntax access uses. The nested joins are driving me crazy.

Where/how in the above to I join to the Titles table???