SELECT maxgroup.groupname, maxgroup.description, maxuser.userid, maxuser.loginid, maxuser.defsite FROM maxgroup JOIN groupuser ON groupuser.groupname=maxgroup.groupname JOIN maxuser ON maxuser.userid=groupuser.userid ORDER BY maxgroup.groupname, maxuser.userid;