SQL Select Query Inner Join

[reggiete]

Hello All,

Could someone help with the SQL query below.

SELECT Tableau.*, "Pass" AS AccessVerification
FROM (Tableau LEFT JOIN AAL_Matrix ON (Tableau.[Access] = AAL_Matrix.[PrimaryRole]) AND (Tableau.[AAL] = AAL_Matrix.[AAL])) INNER JOIN TblApprovedExceptions ON (Tableau.[Access] = TblApprovedExceptions.[Role]) AND (Tableau.[EID] = TblApprovedExceptions.[EID]);

The above queries return the results that match the criteria specified after the INNER join. but the records that match for The Left Join statement do not show up.

 

[reggiete]

Figured it out thanks everyone!