Returning multliple value of a column concatenated

Asked Jul 15 '21 at 20:10

Active Jul 15 '21 at 20:15

Viewed 28 times

I have 3 tables like this.

Person

ID | FirstName | LastName | 
----------------------------
1  | Tim       | yank
2  | Nick      | Thomas
3  | Leo       | Peter
4  | Frank     | Thomas
5  | George    | Hick
6  | Joe       | Moses

Hobbies_person

HobbyID | personID |
----------------------------
1       | 1 
3       | 1
4       | 1
2       | 2
2       | 4
3       | 3
4       | 2
4       | 5
2       | 5
1       | 6

Hobbies :

ID   | Name
------------
1    | Soccer
2    | Fishing
3    | Hiking
4    | Painting

I want to do a query like when i give a person id it should give me first name last name & hobby. If a person has more than 1 hobby (like personid 1) result should be like Tim, Yank, (1, 3, 4)--> all hobbies as a string seperated by a ,

Not able to do the hobbies concatenation.

edited Jul 15 '21 at 20:15

eshirvana

23,227
3
22
38

asked Jul 15 '21 at 20:10

vishal

Check GROUP_CONCAT MySQL command, Btw - is it SQL Server or MySQL? – Lidbey Jul 15 '21 at 20:13
2

you should tag your dbms – eshirvana Jul 15 '21 at 20:16
Does this answer your question? [How to concatenate text from multiple rows into a single text string in SQL server?](https://stackoverflow.com/questions/194852/how-to-concatenate-text-from-multiple-rows-into-a-single-text-string-in-sql-serv) – Stu Jul 15 '21 at 20:18
GROUP_CONCAT works like a charm – vishal Jul 22 '21 at 12:55

Returning multliple value of a column concatenated

0 Answers0