Results 1 to 3 of 3

Thread: 2 TABLEs & MAX of second Table

  1. #1
    Join Date
    Jan 2004
    Location
    France
    Posts
    43

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

  2. #2
    Join Date
    Jan 2004
    Posts
    33
    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);

  3. #3
    Join Date
    Jan 2004
    Location
    France
    Posts
    43

    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
  •