Using GROUP_CONCAT and join

QuestionsUsing GROUP_CONCAT and join
Andy asked 7 years ago

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?

2 Answers
Abu Ghufran answered 7 years ago

Hi,

Can you email me db sql dump and complete sql query that is not working?
I'll test your case here and update you back.

You can email me at [email protected]

Andy Liaw answered 7 years ago

Hi, Abu
Letter sent

Your Answer

12 + 5 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?