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
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.
Please let me know if anyone has a solution.
In response to
pgsql-novice by date
|Next:||From: Vyacheslav Kalinin||Date: 2008-03-03 23:06:50|
|Subject: Re: SQL Question|
|Previous:||From: Tom Lane||Date: 2008-03-03 21:40:33|
|Subject: Re: Function problem after alter table |