1 2 3 4 5 6
| SELECT [Copie de AGR_1251_Y_MERGE_finale_star].UNAME, [Copie de SOD_Tb_Activity].strGroup, [Copie de SOD_Tb_Activity].strObject, [Copie de SOD_Tb_Activity].strField, [Copie de SOD_Tb_Activity].strValue
FROM [Copie de AGR_1251_Y_MERGE_finale_star] INNER JOIN [Copie de SOD_Tb_Activity] ON ([Copie de AGR_1251_Y_MERGE_finale_star].LOW = [Copie de SOD_Tb_Activity].strValue) AND ([Copie de AGR_1251_Y_MERGE_finale_star].FIELD = [Copie de SOD_Tb_Activity].strField) AND ([Copie de AGR_1251_Y_MERGE_finale_star].OBJECT = [Copie de SOD_Tb_Activity].strObject)
GROUP BY [Copie de AGR_1251_Y_MERGE_finale_star].UNAME, [Copie de SOD_Tb_Activity].strGroup, [Copie de SOD_Tb_Activity].strObject, [Copie de SOD_Tb_Activity].strField, [Copie de SOD_Tb_Activity].strValue
HAVING (((Count(*))=(SELECT Count(*)
FROM [Copie de SOD_Tb_Activity] AS U
WHERE U.strGroup = [Copie de SOD_Tb_Activity].strGroup))); |
Partager