AndreB.

Hi @kimmyx,

I had an syntax error. Now the code working perfect. It works with GROUP_CONCAT.

Thanks alot

@kimmyx

I tried it with GROUP_CONCAT (). After pressing the Execute button, however, nothing happens.
The original code looks like this:

SELECT	zkzCrojUwoocommerce_order_items.order_id as 'Order_id'
,		zkzCrojUwoocommerce_order_itemmeta.meta_value as 'Vorname'
FROM	zkzCrojUwoocommerce_order_items
INNER JOIN zkzCrojUwoocommerce_order_itemmeta ON zkzCrojUwoocommerce_order_itemmeta.order_item_id = zkzCrojUwoocommerce_order_items.order_item_id
WHERE	(zkzCrojUwoocommerce_order_itemmeta.meta_key = 'vorname')

The Concat code looks like this:

SELECT	zkzCrojUwoocommerce_order_items.order_id as 'Order_id'
,		GROUP_CONCAT(zkzCrojUwoocommerce_order_itemmeta.meta_value) as 'Vorname'
FROM	zkzCrojUwoocommerce_order_items
INNER JOIN zkzCrojUwoocommerce_order_itemmeta ON zkzCrojUwoocommerce_order_itemmeta.order_item_id = zkzCrojUwoocommerce_order_items.order_item_id
WHERE	(zkzCrojUwoocommerce_order_itemmeta.meta_key = 'vorname')

@kimmyx

I don’t want to combine two columns together, but rows.
After all, CONCAT can only combine columns.

I’ve read that it’s supposed to work with XML Path. However, I haven’t been able to do it yet.

• This reply was modified 1 year, 4 months ago by AndreB..