declare @v_recvaddr varchar(8000)
set @v_recvaddr=''
select @v_recvaddr=@v_recvaddr+','+isnull(recvaddr,'')
from t_newagentorder_h h,t_newagentorder_d d
where h.bill=d.bill and d.orderbill='30060659/SO'
group by recvaddr
set @v_recvaddr=stuff(@v_recvaddr,1,1,'')
select recvaddr=@v_recvaddr
set @v_recvaddr=''
select @v_recvaddr=@v_recvaddr+','+isnull(recvaddr,'')
from t_newagentorder_h h,t_newagentorder_d d
where h.bill=d.bill and d.orderbill='30060659/SO'
group by recvaddr
set @v_recvaddr=stuff(@v_recvaddr,1,1,'')
select recvaddr=@v_recvaddr
你这进行分组,也不能得到我想要得到的答案!