und hier nochmal der Schönheit halber...
SQL-Code:
SELECT K.KUNDENNAME AS Kunde, V.MANU AS Maschinennummer, COUNT(*) AS Anzahl
FROM MANUS V
INNER JOIN SWDATE A
ON V.MANU_ID = A.MANU_ID
INNER JOIN KUNDEN K
ON V.KUND_ID = K.KUND_ID
GROUP BY V.MANU, K.KUNDENNAME
HAVING COUNT(*) > 1