联合查询

select top 20 Users.* ,UserGroup_Member.* from Users,UserGroup_Member where (Users.ID=UserGroup_Member.uid) and (groupid=9)

select top 20 Users.* ,UserGroup_Member.* from Users,UserGroup_Member where (Users.ID=UserGroup_Member.uid) and ((groupid=3) or (groupid=4))

select top 20 Users.Id ,users.Nickname  from Users,UserGroup_Member where (Users.ID=UserGroup_Member.uid) and ((groupid=3) or (groupid=4))

select top 20 Users.Id as newid ,users.nickname as newnickname from Users,UserGroup_Member where (Users.ID=UserGroup_Member.uid) and ((groupid=3) or (groupid=4))

联合查询