SQL, combining the result
- by Newbie
I am using Access and have this SQL
SELECT land.id, land.official_name, vaksiner.vaksiner
FROM land INNER JOIN (vaksiner INNER JOIN land_sykdom ON vaksiner.id = land_sykdom.sykdom) ON land.kort = land_sykdom.land
ORDER BY land.official_name
The SQL gives me a result like this:
id official_name vaksiner
1 a A
1 a C
2 b A
2 b B
2 b C
But I want to combine the result so that it looks like this:
id official_name vaksiner
1 a A, C
2 b A, B, C
