-
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);
-
perfect
thanks a lot one more time !
it works :-))
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|