Need to return one field for multiple Rows
От | Ozer, Pam |
---|---|
Тема | Need to return one field for multiple Rows |
Дата | |
Msg-id | 216FFB77CBFAEE4B8EE4DF0A939FF1D14F87D6@mail-001.corp.automotive.com обсуждение исходный текст |
Ответы |
Re: Need to return one field for multiple Rows
|
Список | pgsql-sql |
<div class="WordSection1"><p class="MsoNormal">I have the following query<p class="MsoNormal"> <p class="MsoNormal">SelectPubArticleId, PubArticlePageXML<p class="MsoNormal">from PubarticlePageXml x<p class="MsoNormal">InnerJoin Pubarticlepage p on x.pubarticlepageid=p.pubarticlepageid <p class="MsoNormal">where pubarticleid=188321<pclass="MsoNormal"> <p class="MsoNormal">Which Returns<p class="MsoNormal">PubArticleId(Integer) PubArticlePageXML(Text)<pclass="MsoNormal">188321 fdfaldkjf<p class="MsoNormal">188321 afdaf<p class="MsoNormal">188321 adfafd<p class="MsoNormal">188321 afddfadfa<p class="MsoNormal"> <p class="MsoNormal"> <p class="MsoNormal"> <p class="MsoNormal">Iwant it to return one row<p class="MsoNormal"> <p class="MsoNormal">188321 fdfaldkjf afdaf adfafd afddfadfa<pclass="MsoNormal"> <p class="MsoNormal"> <p class="MsoNormal">Any thoughts On how I can do this?<p class="MsoNormal"> <pclass="MsoNormal">Thanks<p class="MsoNormal"> <div id="content"><p class="MsoNormal"><b><span style="font-size:11.5pt;font-family:"Arial","sans-serif";color:black">PamOzer</span></b></div></div>
В списке pgsql-sql по дате отправления: