SQL Question

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!!!!! :)

--
Sent via pgsql-novice mailing list (pgsql-novice@[EMAIL PROTECTED]
)
To make changes to your Subscription:
http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-novice