找到你要的答案

Q:SQL to combine several rows into one

Q:SQL结合几排成一

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.

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:

I use Visual Studio, NOT Access to become the result

我正在编写一个程序,它使用Access数据库中的一些数据。

我需要一个查询的结果,将采取(例如)9行,并结合成一行。

这里是原始数据的图片。

这里是我的查询

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

最后anime_genrelist.genrename集团通过插入因为出错。

这里是我需要的结果:

我用Visual Studio,没有进入成为结果

sql  ms-access  visual-studio-2012