Несмотря на DISTINCT, в результате запроса есть повторяющиеся записи

SELECT DISTINCT Projektverknuepfung.ID, Projektverknuepfung.Firma, Projektverknuepfung.Projekt, Projektverknuepfung.status, Firmen.ID, Firmen.Name FROM Firmen INNER JOIN Projektverknuepfung ON Firmen.ID = Projektverknuepfung.Firma WHERE Projektverknuepfung.status=1 OR Projektverknuepfung.status=2 ORDER BY Firmen.ID'

SELECT DISTINCT Firmen.ID, Firmen.Street, Firmen.Telefon
FROM Firmen INNER JOIN Projektverknuepfung ON Firmen.ID = Projektverknuepfung.Firma
WHERE Projektverknuepfung.status=1 OR Projektverknuepfung.status=2;

SELECT DISTINCT Firmen.ID, Firmen.Street, Firmen.Telefon
FROM Firmen INNER JOIN Projektverknuepfung ON Firmen.ID = Projektverknuepfung.Firma
 
WHERE Projektverknuepfung.status=1 OR Projektverknuepfung.status=2;
 
---- Variant 1 --------------
SELECT 
(SELECT TOP 1 F1.ID FROM Firmen AS F1 WHERE P.Firma = F1.ID) AS ID,
(SELECT TOP 1 F2.Street FROM Firmen AS F2 WHERE P.Firma = F2.ID) AS Street,
(SELECT TOP 1 F3.Telefon FROM Firmen AS F3 WHERE P.Firma = F3.ID) AS Telefon
FROM Projektverknuepfung AS P
WHERE P.status=1 OR P.status=2;

---- Variant 2 --------------
SELECT DISTINCT P.Firma,
(SELECT TOP 1 F2.Street FROM Firmen AS F2 WHERE P.Firma = F2.ID) AS Street,
(SELECT TOP 1 F3.Telefon FROM Firmen AS F3 WHERE P.Firma = F3.ID) AS Telefon
FROM Projektverknuepfung AS P
WHERE P.status=1 OR P.status=2;

SELECT Firmen.ID, FIRST(Firmen.Street), FIRST(Firmen.Telefon) 
FROM FROM Firmen INNER JOIN Projektverknuepfung ON Firmen.ID = Projektverknuepfung.Firma
WHERE Projektverknuepfung.status=1 OR Projektverknuepfung.status=2
GROUP BY Firmen.ID;

SELECT DISTINCT Firmen.ID, Firmen.Name, Firmen.Bearbeiter,Firmen.[E-mail],Firmen.OrtPLZ, Firmen.Strasse,Firmen.www, Firmen.Tel
FROM Firmen INNER JOIN Projektverknuepfung ON Firmen.ID = Projektverknuepfung.Firma
WHERE (((Projektverknuepfung.status) = 1 OR (Projektverknuepfung.status) = 2));