SQL Question
| От | Joshua |
|---|---|
| Тема | SQL Question |
| Дата | |
| Msg-id | 47CC79D2.1070802@joshuaneil.com обсуждение исходный текст |
| Ответ на | Re: Function problem after alter table (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: SQL Question
|
| Список | 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!!!!! :)
В списке pgsql-novice по дате отправления: