Best group member,
Many of you probably do not understand the question; neither would I if
someone ask me, so I will explain a little bit more.
This is what I have:
SELECT tps.strokes FROM tour_player_score tps join tour_scorecard_hole tsh
WHERE tour_player_id=175 AND tps.scorecard_hole_id=tsh.id ORDER BY
tsh.hole_number;
This generates this:
+---------+
| strokes |
+---------+
| 6 |
| 4 |
| 5 |
| 3 |
| 5 |
| 4 |
| 4 |
| 3 |
| 6 |
+---------+
I would like to retrieve it in one row instead of many rows with one per
row.
s1 s2 s3 s4 s5 s6 s7 s8 s9
6 4 5 3 5 4 4 3 6
Can this be done?
It can be done roughly with something like ...