I'm working with MySQL 5.1.68.
I have a situation where I'd like to select rows from another table into a column.
I'd like to output this:
id # name # citizen_name (multiple citizen names)
1 # The Hague # Barack Obama, Marc Zuckerberg, George Bush
I know how to do this with multiple queries, but I'd like to do this with just one query. I've been looking at group_concat and concat_ws, but unfortunatly this hasn't brough me the result I was looking for. I've also tried to put the results from a SELECT sub query into a variable and CONCAT those results, but that didin't work either.
My SQL fiddle to show the schema and some test data: http://sqlfiddle.com/#!2/c7c7e/1.
What can I do?