Good afternoon!  I'm trying to build a tool for Access Control and have the following query:

SELECT
    U.UserID,
    U.UserName,
    BF1.BusinessFunctionName AS BusinessFunction1,
    BF2.BusinessFunctionName AS BusinessFunction2,
    BF3.BusinessFunctionName AS BusinessFunction3,
    SRL.SOD_Risk_ID,
    SR.SOD_Risk_Description
FROM
    (Users AS U
INNER JOIN
    UserSystemRoles AS USR_Temp ON U.UserID = USR_Temp.UserID)
INNER JOIN
    (SystemRoles AS SRol_Temp ON USR_Temp.SystemRoleID = SRol_Temp.SystemRoleID)
INNER JOIN
    (SystemRoleBusinessFunctions AS SRBF ON SRol_Temp.SystemRoleID = SRBF.SystemRoleID)
INNER JOIN
    (BusinessFunctions AS BF ON SRBF.BusinessFunctionID = BF.BusinessFunctionID)
INNER JOIN
    (SOD_Risk_Lookup AS SRL ON BF.BusinessFunctionID = SRL.BusinessFunctionID1)
LEFT JOIN SOD_Risks AS SR ON SRL.SOD_Risk_ID = SR.SOD_Risk_ID
LEFT JOIN BusinessFunctions AS BF1 ON SRL.BusinessFunctionID1 = BF1.BusinessFunctionID
LEFT JOIN BusinessFunctions AS BF2 ON SRL.BusinessFunctionID2 = BF2.BusinessFunctionID
LEFT JOIN BusinessFunctions AS BF3 ON SRL.BusinessFunctionID3 = BF3.BusinessFunctionID
WHERE EXISTS (
    SELECT 1
    FROM SystemRoleBusinessFunctions AS SRBF2
    INNER JOIN SystemRoles AS SRol2 ON SRBF2.SystemRoleID = SRol2.SystemRoleID
    INNER JOIN UserSystemRoles AS USR2 ON SRol2.SystemRoleID = USR2.SystemRoleID
    INNER JOIN BusinessFunctions AS BF_Matching ON SRBF2.BusinessFunctionID = BF_Matching.BusinessFunctionID
    WHERE USR2.UserID = U.UserID
    AND (BF_Matching.BusinessFunctionID = SRL.BusinessFunctionID2
    OR BF_Matching.BusinessFunctionID = SRL.BusinessFunctionID3)
)
;

I keep getting a syntax error on the second Inner Join "ON"--UserSystemRoles AS USR_Temp ON U.UserID = USR_Temp.UserID) I have double checked the relationships, the accuracy of the fields' names and table name.  I'm going crazy on this!