5 Replies Latest reply on Mar 1, 2012 3:46 PM by Mark Johnson

    simple SQL query question

    Walter Bednarz

      I am somewhat new to SQL queries. Limited exposure over the years but am working on learning more.

       

      I created the query below. Instead of presenting GroupID in the results, I would like to return the corresponding Groupname from the Groups table. How do I do that with this query?

       

      select Username, FullName, GroupID

      from Users

      join GroupMembers

      on Users.UserID=GroupMembers.UserID

      order by Username