I need to produce a single row with a concatenated value for a single column from multiple rows. To make it simple, something like this...
"Select lastname, <all firstnames> from persontable".
I also need another query to maintain a running total. Again to make it simple, something like this...
"Select employee, salary, <running salary total> from employeetable".
Thanks for your help!
DB