PHP Forum - MySQL Abfrage innerhalb einer Abfrage

z.B. möchte ich hier SELECT CONCAT(products_model,products_options_values) from orders_products,orders_products_attributes) as ArtikelnummerShop einfügen aber kommt immer der Fehler: Cannot retrieve Resultset Data

PHP-Code:


		
			
SELECT

          orders.orders_id as orderID,

          orders.orders_id as BestellnummerShop,

          orders.date_purchased as Bestelldatum,

          orders.shipping_class as Lieferart,

          orders.payment_class as Zahlungsart,

          orders_total.value as FrachtkostenBrutto,

          orders.comments as AnmerkungenBestellung,

          (SELECT CONCAT(products_model,products_options_values) from orders_products,orders_products_attributes) as ArtikelnummerShop,

          orders_products.products_quantity as Menge,

          orders_products.products_price as abweichenderEinzelpreisBrutto,

          orders_products.products_tax as abweichendeMwStProzent

        FROM orders

         INNER JOIN 

          orders_products ON (orders.`orders_id` = `orders_products`.`orders_id`)

         INNER JOIN

          orders_total ON (orders.`orders_id` = `orders_total`.`orders_id` AND orders_total.class = 'ot_shipping')

         LEFT OUTER JOIN

          banktransfer ON (orders.`orders_id` = `banktransfer`.`orders_id`)

        WHERE

          orders_status = '1'