Postgres Pro
Downloads
Home   >   mailing lists

SQL Question - Mailing list pgsql-novice

From Joshua
Subject SQL Question
Date
Msg-id 47CC79D2.1070802@joshuaneil.com
Whole thread Raw
In response to Re: Function problem after alter table  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: SQL Question
List pgsql-novice
Tree view 
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!!!!! :)

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Function problem after alter table
Next
From: "Vyacheslav Kalinin"
Date:
Subject: Re: SQL Question