Hello, it may be something very simple that I'm missing, but I cant seem to figure this out... we have 2 tables and a linking table: Users (UserID, UserName, etc) Group(GroupID, GroupName, etc) UsersInGroup(LinkID, GroupID, UserID) Simple enough... Now, I want to display the users where GroupID = 1... So I select all in UsersInGroup where GroupID = 1; that gives me all the users... Now, I want to sort them by name... How would I do that? I cant use the ORDER command in the SQL code because the username isnt even in the UsersInGroup, only the UserID exists there. Thank you in advance! [img src=\"style_emoticons/[#EMO_DIR#]/smile.gif\" style=\"vertical-align:middle\" emoid=\":smile:\" border=\"0\" alt=\"smile.gif\" /]