Hi guys/girls
I am having a problem with SQL. Its kinda hard to explain but going to try
I have a query returning results as shown in the example:
name,surname,telno,result
john,joe,011,45
john,joe,011,55
john,joe,011,50
piet,pee,011,30
piet,pee,011,44
piet,pee,011,45
piet,pee,011,45
and I want to get the results like so
john,joe,011,45,55,50
piet,pee,011,40,44,45,45
The problem I am having is that the number of result per person is not always the same number, example john has 3 results , and piet has 4 results and so on.
Please note that the "," is for a new column
Can anyone assist with this please ?