;with sel as (
	select a.ordname,a.ordstate,c.goodsname,e.agentname
	from @a a
	Left Outer Join @goodsLink b on b.order_id=a.orderid
	Left outer Join @goods c on c.goods_id=b.goodsid
	Left Outer Join @agentsLink d on d.order_id=a.orderid
	Left outer Join @agents e on e.agent_id=d.agentid
	where a.orderid>3
	--where (e.agentname like 'Adams%')and (ordstate='done')
	)
select s.ordname,s.ordstate, 
	stuff((
		select '+'+a.goodsname
		from sel a
		where a.ordname=s.ordname and a.ordstate=s.ordstate
		group by a.goodsname
		order by a.goodsname
		for xml path(''),type 
		).value('.', 'nvarchar(max)'),1,1,'') goodsname,
	stuff((
		select '+'+a.agentname
		from sel a
		where a.ordname=s.ordname and a.ordstate=s.ordstate
		group by a.agentname
		order by a.agentname
		for xml path(''),type 
		).value('.', 'nvarchar(max)'),1,1,'') agentname
from sel s
group by s.ordname,s.ordstate