[blinks2]

Problem solved –

group_concat(DISTINCT searchkey_author.rk_author ORDER BY searchkey_author.rk_author DESC SEPARATOR ';') AS rk_author

Thanks!

[blinks2]

Peter, thank you for your reply. A simpler example and resulting output is –

SELECT

searchkey.rk_id AS rk_id,

searchkey.rk_title AS rk_title,

searchkey_author.rk_author AS rk_author,

searchkey_keywords.rk_keywords AS rk_keywords

FROM searchkey

LEFT JOIN searchkey_author ON rk_id=rk_author_id

LEFT JOIN searchkey_keywords ON rk_id=rk_keywords_id

WHERE rk_id=”12345″;

yields the following output –

rk_id rk_title rk_author rk_keywords

12345 Why physics is the best Brown, B Australia

12345 Why physics is the best Brown, B physics

12345 Why physics is the best Smith, J Australia

12345 Why physics is the best Smith, J physics

whereas the output I want is –

rk_id rk_title rk_author rk_keywords

12345 Why physics is the best Brown, B; Smith, J Australia; physics

[Author]

Posts