MySQL Join Problem

[Ilja]

yo,

SELECT spalten
FROM benutzertabelle AS b
LEFT JOIN gruppenzuordnungstabelle AS g
ON (b.kunden_nr = g.kunden_nr)
WHERE g.gruppen_id=12
AND g.kunden_nr IS NULL;

Ilja