关于单行子查询的小问题！在线等。。多谢了

[sk2002]

select gpcs_placereturndtl.placereturnid,sum(zx_resa_goods_price.price*gpcs_placereturndtl.goodsqty)
from zx_resa_goods_price,gpcs_placereturndtl
where placereturnid in (380000108,380000109,380000110)
and zx_resa_goods_price.goodsid=gpcs_placereturndtl.goodsid
and zx_resa_goods_price.subshopid=(select placepointid
from gpcs_placereturn_v)
group by placereturnid;
结果显示单行子查询返回多于一行，如果我想多行显示，该怎么修改，请各位帮忙呀！

[yujohny]

TRY:
select gpcs_placereturndtl.placereturnid,
sum(zx_resa_goods_price.price*gpcs_placereturndtl.goodsqty)
from zx_resa_goods_price,gpcs_placereturndtl
where placereturnid in (380000108,380000109,380000110)
and zx_resa_goods_price.goodsid=gpcs_placereturndtl.goodsid
and zx_resa_goods_price.subshopid in (select placepointid
from gpcs_placereturn_v)
group by placereturnid

[sk2002]

多谢了，可以了！

[welyngj]

select b.placereturnid,sum(a.price*b.goodsqty)
from zx_resa_goods_price a,gpcs_placereturndtl b
where placereturnid in (380000108,380000109,380000110)
and a.goodsid=b.goodsid
and a.subshopid in(select placepointid
from gpcs_placereturn_v)
group by placereturnid

[lijinqiang]

yujohny(踏网无痕) 的正确但GROUP BY 中应该加上placereturnid

[sk2002]

我想问一下 ，为什么我原来写的不可以呢？

[yujohny]

错在这句
and zx_resa_goods_price.subshopid=(select placepointid
from gpcs_placereturn_v)
为什么错呢？
因为select placepointid from gpcs_placereturn_v这句查询出来的是一个记录集
也就是相当于一个集合，所以不能用=要用in