B_gd_n[ ]Sahlean:

SELECT
A.*
FROM A
JOIN B
ON A.a=B.a AND A.c=B.c AND A.d=B.d AND A.e=B.e

eventual

SELECT DISTINCT
A.*
FROM A
JOIN B
ON A.a=B.a AND A.c=B.c AND A.d=B.d AND A.e=B.e

Deci eu folosesc SQL in Access ia propozitie de forma "FROM A JOIN B ON " nu merge cere ori Inner ori Left... sau altceva...