MySQL doppelte Datensätze anzeigen...

[omata]

Hallo NetSonic,

vielleicht so...

SQL-Code:

SELECT * 
FROM tblkunden x
WHERE COALESCE(nachname, '') <> ''
  AND COALESCE(vorname, '') <> '' 
  AND EXISTS (SELECT nachname, vorname
              FROM tblkunden
              WHERE nachname = x.nachname
                AND vorname = x.vorname
              GROUP BY nachname, vorname
              HAVING COUNT(*) > 1)
ORDER BY nachname, vorname

Gruss
Thorsten