子查询返回的值多于一个。当子查询跟随在 =、!=、<、<=、>、>= 之后或子查询用作表达式时这种情况是不允许

select id,mingcheng,tupian,shijian,(select name from fenlei where id in(select fenlei from shangpin where bianhao=@bianhao)) as fenlei3,(select name from fenlei where id in(select upid from fenlei where name in(select name from fenlei where id in(select fenlei from shangpin where bianhao=@bianhao)))) as fenlei2,(select name from fenlei where id in(select upid from fenlei where name in(select name from fenlei where id in(select upid from fenlei where name in(select name from fenlei where id in(select fenlei from shangpin where bianhao=@bianhao)))))) as fenlei1 from shangpin where bianhao=@bianhao

编译通过的说明语法没错，不知道什么情况

相关了解……