SELECT DISTINCT [A].[NU SAL], [A].[NOM PRENOM], [A].AD1, [A].AD2, [A].AD3, [A].CODEPOST, [A].COMMUNE, entreprises.[NU ENT], entreprises.[LIBELLE ENT]
FROM entreprises, A, B
WHERE (((entreprises.[NU ENT])=[A]![NU ENT]))
AND [A]![NU SAL] NOT IN (SELECT [B].[NU SAL] FROM B); |