2 TABLEs & MAX of second Table
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 !!