SELECT (DISTINCT) spaltenname_oder_ausdruck FROM tabellen_name(n) JOIN andere_tabelle ON join_bedingung (WHERE) zeilen_bedingung GROUP BY gruppierungsspalte HAVING gruppenbedingung ORDER BY ordnungs_spalte ASC [DESC] LIMIT anzahl “ Your browser does not support the audio tag.