Hello Team ,
So i have this little problem and i don't want to solve it using php ...
I have 3 tables :
- board (kind of ads)
- generic_list (contains lists of tags)
- board_relations (it contains tags/associated with the board)
the board relations table contains the id of the board , the id of the generic list and the value .
is there a way for a query to give me the following :
Info of the board table , then inside another field a list of the values of a specific generic_list .
i currently have the following query :
Inner Join jos_hpj_users_boards_relations ON jos_hpj_users_boards.id = jos_hpj_users_boards_relations.boardId
Inner Join hpj_genericlist ON jos_hpj_users_boards_relations.listId = hpj_genericlist.idList
which returns something like :
I want something like :
here is my generic list :
and finally my relation board :
is there a way to do that in Mysql ?