SQL CASE COUNT()

[Pikachu]

Probiers mal so:

SELECT FELD1, COALESCE(ANZAHL, 0) 
FROM DATEI1 LEFT OUTER JOIN ( 
SELECT FELD2, COUNT(*) AS ANZAHL 
FROM DATEI2 GROUP BY FELD2) AS D2 ON FELD1=FELD2