Peter,
Peter Brawley said:
SELECT
...,
GROUP CONCAT(LPAD(strokes,3,' ') SEPARATOR '') AS ' 1 2 3 4 5 6 7
8 9'
FROM tour_player_score tps
INNER JOIN tour_scorecard_hole tsh ON tps.scorecard_hole_id=tsh.id
WHERE tour_player_id=175
GROUP BY tsh.id
This worked, however, it gives me
Peter Brawley said:
SELECT
...,
GROUP CONCAT(LPAD(strokes,3,' ') SEPARATOR '') AS ' 1 2 3 4 5 6 7
8 9'
FROM tour_player_score tps
INNER JOIN tour_scorecard_hole tsh ON tps.scorecard_hole_id=tsh.id
WHERE tour_player_id=175
GROUP BY tsh.id
: Robert DiFalco [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 11, 2006 12:47 AM
To: Peter Lauri; mysql@lists.mysql.com
Subject: RE: Making result rows to one row
Can you tell us more about the use case? Why does this need to be in a
single row? Maybe instead of figuring out how to get this into a
Peter,
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
Can you tell us more about the use case? Why does this need to be in a
single row? Maybe instead of figuring out how to get this into a single
row we could instead figure out how to solve the problem that requires
it to be in a single row.
-Original Message-
From: Peter Lauri [mailto:[EMA
