2 Tables >>>>

------------------

Member

id_Member
Name

-----------------

MemberNumber

id_MemberNumber
id_Member
MemberNumber
Alias

-----------------
-----------------

sp_UnicAlias

SELECT Max(MemberNumber.MemberNumber) AS MaxNumber, Member.id_Member, MemberNumber.Alias
FROM Member INNER JOIN MemberNumber ON Member.id_Member = MemberNumber.id_Member
GROUP BY Member.id_Member, MemberNumber.Alias;


-----------------


and I get all ! I want only the Alias where the number is the biggest




thank you for helping !!