(LEFT JOIN PAY_PERIOD_DIM COV ON COV.FISCAL_YEAR=CD.FiscalYear AND COV.PAY_PERIOD=CD.Measure_Type)
( INNER JOIN PAYROLL P ON CD.Name=P.Employee)
Any response/input will be highly appreciated as I'm new to MS Access syntax and struglling with this whole day.