Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

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


pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group