AnsweredAssumed Answered

simple SQL query question

Question asked by Walter Bednarz on Feb 28, 2012
Latest reply on Mar 1, 2012 by Mark Johnson

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

Outcomes