update a set MemberMingjiId=b.Id from Blog a,MemberMingji b
where a.Id=b.BlogId and a.Id in (
select top 47 Id from Blog
where Type=1 and IsAudited=1 order by MemberMingjiId
where a.Id=b.BlogId and a.Id in (
select top 47 Id from Blog
where Type=1 and IsAudited=1 order by MemberMingjiId
)
MemberMingjiId 表中的blogId 是外键====Blog表id(存在外键关系)