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
编译通过的说明语法没错,不知道什么情况
子查询中返回了一条记录以上,你需要自己查看一下哪里会返回多个结果,如果不确定,可以用top 1 来做子查询
温馨提示:答案为网友推荐,仅供参考
第1个回答 2008-10-28
老大,你写好点,在给我们看行吗?