SQL to combine several rows into one

Asked May 02 '15 at 09:05

Active May 03 '15 at 09:46

Viewed 99 times

I am writing a program which uses some data from an Access database.

I need a query for a result that will take (for example) 9 rows and combine it into a single row.

Here is a picture of the raw data.

enter image description here

Here is my query

SELECT 
    anime.animeID, anime.animeOriginaltitel, anime.animejapanesetitel, anime.animesolved, anime.animeLicensed, anime.animeproxerID, anime.animeseasonstart, 
    anime.animeseasonend, anime.animedescription, anime.animeEpisodes, anime_genrelist.genreName AS Genre
FROM
    ((anime INNER JOIN
      anime_anime_genre ON anime.animeID = anime_anime_genre.animeID) INNER JOIN
      anime_genrelist ON anime_anime_genre.genreID = anime_genrelist.genreID)
GROUP BY 
    anime.animeID, anime.animeOriginaltitel, anime.animejapanesetitel, anime.animesolved, anime.animeLicensed, anime.animeproxerID, anime.animeseasonstart, 
    anime.animeseasonend, anime.animedescription, anime.animeEpisodes, anime_genrelist.genreName

The last anime_genrelist.genreName at group by is inserted because there was an error.

Here is the result I need:

enter image description here

I use Visual Studio, NOT Access to become the result

edited May 03 '15 at 09:46

shA.t

16,580
5
54
111

asked May 02 '15 at 09:05

Florian Hofmeister

What exactly is the problem? They are not grouped together as the genre is different (from what I'm seeing..) – Alexandr May 02 '15 at 09:10
Your question is not much clear, please elaborate a bit – rohit singh May 02 '15 at 09:10
i have add an picture of the needed result – Florian Hofmeister May 02 '15 at 09:21
possible duplicate of [Combine values from related rows into a single concatenated string value](http://stackoverflow.com/questions/13278590/combine-values-from-related-rows-into-a-single-concatenated-string-value) – Gord Thompson May 02 '15 at 09:23
sorry but when i use this solution i become the error Undefined function 'ConcatRelated' in expression – Florian Hofmeister May 02 '15 at 09:36
i use visual studio NOT access to become the query – Florian Hofmeister May 02 '15 at 09:52
@FlorianHofmeister the VBA function is located here http://allenbrowne.com/func-concat.html – WorkSmarter May 02 '15 at 14:08
i know but i need an sql solution not with an modul from vb because i wrote in the visual studio query editor and there i can only use SQL – Florian Hofmeister May 02 '15 at 18:30
Pls give me some Answere – Florian Hofmeister May 11 '15 at 06:29

SQL to combine several rows into one

0 Answers0