Probleme mit SQL-Query

[Ilja]

yo,

hier mal ein beispiel, die beiden unterabfragen kannst du für die beiden anderen fälle erweitern.

SELECT t1.orders_id, t1.orders_products_id, t1.products_attributes_model,
       t1.products_options, t1.products_options_values,
       t1.options_values_price, t1.price_prefix,
       (SELECT t2.products_options
        FROM tabelle t2
        WHERE t2.products_options = 'Besaiten'
        AND t2.order_id = t1.order_id
       ),
       (SELECT t2.products_options_values
        FROM tabelle t2
        WHERE t2.products_options = 'Besaiten'
        AND t2.order_id = t1.order_id
       )
FROM tabelle t1
WHERE t1.products_options = 'Griffstärke'
;

Ilja