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