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