Answer the question
In order to leave comments, you need to log in
Libre ofice base - how to combine data from multiple rows into one (GROUP CONCAT)?
The main table, "entities" is related to another table, "entity properties" by a one-to-many relationship. It is necessary in the resulting query to get a table of the form: сущность | все свойства сущности
Where all the properties of the entity are specified separated by a comma or another separator, or at least somehow.
On MySQL, I did this very easily through GROUP_CONCAT(the desired column, SEPARATOR ','), but here, when I try to do this, I get Access Denied.
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question