Alıntı
SELECT order_product.order_product_id, order_product.order_id, order_product.name, order_product.quantity, order_option.order_product_id, order_option.name, order_option.value
FROM order_product
LEFT OUTER JOIN order_option ON order_product.order_product_id = order_option.order_product_id
WHERE order_product.order_id = '158'
GROUP BY order_product.order_id
Sadece name, value için

Alıntı
SELECT order_product.name, order_option.value
FROM order_product
LEFT OUTER JOIN order_option ON order_product.order_product_id = order_option.order_product_id
WHERE order_product.order_id = '158'
GROUP BY order_product.order_id