Hast Du Distinct schon probiert?
SELECT DISTINCT
UserA.Uservorname,
UserB.Uservorname
FROM
UserA INNER JOIN UserB
ON (UserA.UserNummer = UserB.Usernummer)
ORDER BY
UserA.`Uservorname
nicht angemeldet nicht angemeldetHast Du Distinct schon probiert?
SELECT DISTINCT
UserA.Uservorname,
UserB.Uservorname
FROM
UserA INNER JOIN UserB
ON (UserA.UserNummer = UserB.Usernummer)
ORDER BY
UserA.`Uservorname