Jump to content

thunderroms

Members
  • Posts

    2
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

thunderroms's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. Nice, it works just like i wanted, thanks!
  2. 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\" /]
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.