I
I
ITicDigger2018-11-01 10:09:21
libreoffice
ITicDigger, 2018-11-01 10:09:21

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 question

Ask a Question

731 491 924 answers to any question