Greetings. Help is needed.
If the grid to use the command:
LEFT OUTER join (SELECT id_shop, GROUP_CONCAT(size) as size_tovar FROM size group by id_shop) size_table on (shop.id=size_table.id_shop)
in phpmyadmin it works.
then we get an error when loading:
Couldn't execute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'on
Why does not this request?
If I make a nested select:
(SELECT GROUP_CONCAT(size) FROM size where shop.id=size.id_shop) as size_tovar
the search does not work.
I actually need to enable search on this field.
What should I do?