Как в Access сделать Join по двум и более полям

SELECT sortament.strSortament AS Sortament,
       sortament.strGOST AS SortamentGOST,
       material.strMaterial AS Material,
       material.strGOST AS MaterialGOST,
       SUM(tesh_spec.fNorm) AS SumWeight,
       SUM(NULL) AS SumCount,
       SUM(material_price.fLInKg)*SumWeight AS fLInKg,
       SUM(material_price.fMMRInKg)*SumWeight AS fMMRInKg,
       SUM(material_price.fMMInKg)*SumWeight AS fMMInKg
FROM (((Contract LEFT JOIN tesh_spec ON Contract.Id=tesh_spec.IdContract)
     LEFT JOIN material ON tesh_spec.IdMaterial=material.Id)
     LEFT JOIN sortament ON tesh_spec.IdProfile=sortament.Id)
     LEFT JOIN material_price ON (IIF(ISNULL(tesh_spec.idName),0,tesh_spec.idName)=IIF(ISNULL(material_price.idName),0,material_price.idName))AND
                                 (IIF(ISNULL(tesh_spec.idMaterial),0,tesh_spec.idMaterial)=IIF(ISNULL(material_price.idMaterial),0,material_price.idMaterial))AND
                                 (IIF(ISNULL(tesh_spec.idProfile),0,tesh_spec.idMaterial)=IIF(ISNULL(material_price.idProfile),0,material_price.idProfile))
WHERE (Contract.IsSelected=TRUE)AND
      (tesh_spec.IsDeleted=FALSE)AND
      (NOT ISNULL(tesh_spec.idMaterial))AND
      (NOT ISNULL(tesh_spec.idProfile))AND
      (sortament.strSortament <>'Отл.')AND
      (sortament.strSortament <>'Поковка')
GROUP BY sortament.strSortament,
         sortament.strGOST,
         material.strMaterial,
         material.strGOST

SELECT anketa.id_employee, tmp_stat.c_date, tmp_stat.count, tmp_stat.employee, extra.info, tmp_stat.user_done, extra.number
FROM anketa, tmp_stat INNER JOIN extra ON extra.info LIKE tmp_stat.user_done & "*"
WHERE (((tmp_stat.employee)=anketa_okv.employee) AND ((extra_manual.name_group)="ns"))
ORDER BY tmp_stat.employee, tmp_stat.c_date;