SQL Question

From: Joshua <joshua(at)joshuaneil(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: SQL Question
Date: 2008-03-03 22:21:06
Message-ID: 47CC79D2.1070802@joshuaneil.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello,

Please let me know if you can assist.... consider the following table
via the following sql statement:

SELECT ronum, jobnum, jobcode FROM slrojobs WHERE ronum = '56890' ORDER
BY jobnum

The above query retrieves the following results....

ronum jobnum jobcode
56890 1 FLPQ
56890 2 W

My question is this. I want to list the 'jobcodes' as follows for each
ronum in 1 field returned that is comma seperated.

FLPQ, W

Please let me know if anyone has a solution.
Thanks!!!!! :)

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Vyacheslav Kalinin 2008-03-03 23:06:50 Re: SQL Question
Previous Message Tom Lane 2008-03-03 21:40:33 Re: Function problem after alter table