子查询返回的值不止一个

System.Data.SqlClient.SqlException: 子查询返回的值不止一个。当子查询跟随在 =、!=、 <、 <=、>、>= 之后，或子查询用作表达式时，这种情况是不允许的。

select Business_Id,Business_Title,Business_KeyWord,Business_Validity from
(
select Business_id,Business_Title,Business_KeyWord,Business_Validity,Row_Number() over(order by Business_Id) as rownum from business where business_Id =
(
select Business_Id from MyBusi where Member_Id=@MemberId
)
)
as mybusi where rownum>((@PageNum-1)*@PageSize)and rownum<=(@PageNum*@PageSize)
应将红色等于号改为：in