When I run this:
SET meta_description_se = meta_description_se +
(SELECT ean FROM skus WHERE sku_product = 55902
AND ean IS NOT NULL
GROUP BY ean )
WHERE product_id = 55902
I get this:
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.
There are 3 rows returned in the sub query and I am trying to just hold them in a bigger field in another table for reference.
Is there as way to convert the output of the sub query so it will be allowed to insert/update. Or do I need to flip this around and iterate through the sub query and write to meta data table on item at a time.