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 !!

I think this is what you require

SELECT MemberNumber.id_MemberNumber, MemberNumber.id_Member, MemberNumber.MemberNumber, MemberNumber.Alias
FROM MemberNumber
WHERE MemberNumber.MemberNumber = (Select MAX(MemberNumber1.MemberNumber) from MemberNumber as MemberNumber1 where memberNumber1.id_member = MemberNumber.id_Member);

thanks a lot one more time !

it works :-))