关于单行子查询的小问题!在线等。。多谢了
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;
结果显示单行子查询返回多于一行,如果我想多行显示,该怎么修改,请各位帮忙呀!