create table MemberInfo

(

    MemberID int,接中加条件查

    MemberName nvarchar(50)

)

create table MemberSort

(

    MemberId int,

    SortNumber int,

    MemberType int

)

insert into MemberInfo values (1,A)

insert into MemberInfo values (2,B)

insert into MemberInfo values (3,C)

insert into MemberInfo values (4,D)

insert into MemberInfo values (5,E)

insert into MemberSort values (1,5,0)

insert into MemberSort values (2,4,0)

insert into MemberSort values (3,3,1)

--Drop table MemberInfo

--Drop table MemberSort