如下语句一直显示子查询返回多个行.真不知道错在那里了.
大家帮我看看啊.我在线等啊.谢谢了.
---------------------------------------------------
update basplushp table1
set (table1.maxqty,table1.minqty)=(
select table2.maxqty,table2.minqty
from basplushp a where a.pluid in(
select b.pluid from basplumain b
where left(b.pluno,3)in(150,155,300,250,270)) and a.shpid=1) where table1.pluid in(select table4.pluid from basplumain table4
where ( left (table4.pluno,3) in (150,155,300,250,270) ) and table4.pluid in(
select ze.pluid from basplushp ze where (ze.shpid=1))) and (table1.shpid=3)
大家帮我看看啊.我在线等啊.谢谢了.
---------------------------------------------------
update basplushp table1
set (table1.maxqty,table1.minqty)=(
select table2.maxqty,table2.minqty
from basplushp a where a.pluid in(
select b.pluid from basplumain b
where left(b.pluno,3)in(150,155,300,250,270)) and a.shpid=1) where table1.pluid in(select table4.pluid from basplumain table4
where ( left (table4.pluno,3) in (150,155,300,250,270) ) and table4.pluid in(
select ze.pluid from basplushp ze where (ze.shpid=1))) and (table1.shpid=3)
后面的子查询返回多行了,这样update就会出错的
a.maxqty,a.minqty只是忘记改了.这不是错.
-----------------------------------------
set后面的查询我也分开检察的.和下面的where是一样多.
就不知道那里错了.
完成了.多谢谢朋友啊.里面在set后面的where 少判断了一次.写好了.