Merge records or more into one in SQL

Question

So I have this query:

SELECT * 
FROM `Nieuws`
INNER JOIN `Nieuws_tags` ON `Nieuws_tags`.`ID-Nieuws` = `Nieuws`.`ID` 
INNER JOIN `Tags` ON `Tags`.`ID` = `Nieuws_tags`.`ID-tags` 
WHERE Nieuws.ID = 1

Right now my output is:

What I need:

So I need one record where the "Beschrijving" (tag) stack up and not give me 2 records.

Someone told me about GROUP_CONCAT but I don't really know how to insert that if necessary.

@jarlh not on SO, that was a hard lesson I've learned here :-) — Alex, Feb 20 '19 at 14:51
I think it's answered here https://stackoverflow.com/questions/194852/how-to-concatenate-text-from-multiple-rows-into-a-single-text-string-in-sql-serv It also depends a bit on the DBMS - some have specific commands to handle this — Erik Reder, Feb 20 '19 at 14:51
@ErikReder, that's an answer for SQL Server, that doesn't work with MySQL. — jarlh, Feb 20 '19 at 14:52
@Alex Sorry, SO wanted me to put more tags in so and I'm new to this. Thanks though. — Thijs van Rijn, Feb 20 '19 at 14:55
@Thijs, I have answered 408 questions. All of those questions have had the tag too. — jarlh, Feb 20 '19 at 14:57
It's perfectly fine. As long as a question is about the SQL language, you should also add a dbms tag! — jarlh, Feb 20 '19 at 15:00
Which MySQL version are you using? `only_full_group_by` may become an issue when upgrading to a more recent MySQL version. — jarlh, Feb 20 '19 at 15:03

score 1 · Accepted Answer · answered Feb 20 '19 at 14:49

It is not 100% clear what is your DB schema, but just to show you the usage of GROUP_CONCAT function:

SELECT Nieuws.*,
       GROUP_CONCAT(Tags.Beschrijving)
FROM `Nieuws`
INNER JOIN `Nieuws_tags` 
ON `Nieuws_tags`.`ID-Nieuws` = `Nieuws`.`ID` 
INNER JOIN `Tags` 
ON `Tags`.`ID` = `Nieuws_tags`.`ID-tags` 
WHERE Nieuws.ID = 1
GROUP BY Nieuws.ID

Merge records or more into one in SQL

1 Answers1