I have a sqlite-database with the schema
Articles
Id
Name
Tags
Id
Name
ArticlesTags
Id
ArticleId
TagId
I´m trying to query for Articles.Name and a LIST of tags. Basically what I would want is:
Name1, (tag1,tag2,tag3)
Name2, (tag3,tag2)
Is this possible? I´m lacking the language to explain what I actually want to do, what is it called?
I found Combine column from multiple rows into single row but it seems limited to SQLServer and the usage of builtin xml-features of that.