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