sql语句出错如何解决呀

sql语句出错怎么解决呀
update dzhhq set mnote = 0 where mnote in(select dzhhq.mnote,b.bs from dzhhq inner join (select bs,stkcode from buysell) b on dzhhq.stkcode=b.stkcode) ;
提示出错信息如下：

Query Error: only a single result allowed for a SELECT that is part of an expression Unable to execute statement

------解决方案--------------------
update dzhhq set mnote = 0 where mnote in(select dzhhq.mnote,b.bs from dzhhq inner join (select bs,stkcode from buysell) b on dzhhq.stkcode=b.stkcode) ;、

改成

update dzhhq set mnote = 0 where mnote in(select dzhhq.mnote from dzhhq inner join (select bs,stkcode from buysell) b on dzhhq.stkcode=b.stkcode) ;