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