[SQL] Need to return one field for multiple Rows

[Ozer, Pam]

I have the following query

 

Select PubArticleId, PubArticlePageXML

from PubarticlePageXml x

Inner Join Pubarticlepage p on x.pubarticlepageid=p.pubarticlepageid 

where pubarticleid=188321

 

Which Returns

PubArticleId(Integer)    PubArticlePageXML(Text)

188321                  fdfaldkjf

188321                  afdaf

188321                  adfafd

188321                  afddfadfa

 

 

 

I want it to return one row

 

188321 fdfaldkjf afdaf adfafd afddfadfa

 

 

Any thoughts On how I can do this?

 

Thanks

 

Pam Ozer