Hallo zusammen,
ich arbeite mich aktuell in das Thema Datenbanken ein und bin dabei auf ein Problem gestoßen, welches ich mir nicht erklären kann.
Und zwar erhalte ich bei der Anwendung von mehreren FULL OUTER JOINS einen Syntax-Fehler. Ich hoffe, ihr könnt mir helfen.
Vielen Dank!
Moritz
SELECT
6f45e_orders.id_order,
6f45e_orders.date_add,
6f45e_orders.id_customer,
6f45e_orders.id_cart,
6f45e_orders.id_address_delivery,
6f45e_orders.current_state,
6f45e_cart_product.id_product,
6f45e_cart_product.quantity,
6f45e_customer.firstname,
6f45e_customer.lastname,
6f45e_customer.email,
6f45e_product.price,
6f45e_address.address1,
6f45e_address.address2,
6f45e_address.postcode,
6f45e_address.city,
6f45e_address.phone,
6f45e_address.phone_mobile,
6f45e_preferred_delivery_time.preferred_date,
6f45e_preferred_delivery_time.preferred_time,
6f45e_message.message
FROM
6f45e_orders FULL
OUTER JOIN 6f45e_cart_product ON 6f45e_orders.id_cart = 6f45e_cart_product.id_cart FULL
OUTER JOIN 6f45e_customer ON 6f45e_orders.id_customer = 6f45e_customer.id_customer FULL
OUTER JOIN 6f45e_product ON 6f45e_cart_product.id_product = 6f45e_product.id_product FULL
OUTER JOIN 6f45e_address ON 6f45e_orders.id_address_delivery = 6f45e_address.id_address FULL
OUTER JOIN 6f45e_preferred_delivery_time ON 6f45e_preferred_delivery_time.id_cart = 6f45e_orders.id_cart FULL
OUTER JOIN 6f45e_message ON 6f45e_message.id_order = 6f45e_orders.id_order
WHERE
6f45e_cart_product.quantity > 0
AND 6f45e_orders.current_state != 5
AND 6f45e_orders.current_state != 6
ich arbeite mich aktuell in das Thema Datenbanken ein und bin dabei auf ein Problem gestoßen, welches ich mir nicht erklären kann.
Und zwar erhalte ich bei der Anwendung von mehreren FULL OUTER JOINS einen Syntax-Fehler. Ich hoffe, ihr könnt mir helfen.
Vielen Dank!
Moritz
SELECT
6f45e_orders.id_order,
6f45e_orders.date_add,
6f45e_orders.id_customer,
6f45e_orders.id_cart,
6f45e_orders.id_address_delivery,
6f45e_orders.current_state,
6f45e_cart_product.id_product,
6f45e_cart_product.quantity,
6f45e_customer.firstname,
6f45e_customer.lastname,
6f45e_customer.email,
6f45e_product.price,
6f45e_address.address1,
6f45e_address.address2,
6f45e_address.postcode,
6f45e_address.city,
6f45e_address.phone,
6f45e_address.phone_mobile,
6f45e_preferred_delivery_time.preferred_date,
6f45e_preferred_delivery_time.preferred_time,
6f45e_message.message
FROM
6f45e_orders FULL
OUTER JOIN 6f45e_cart_product ON 6f45e_orders.id_cart = 6f45e_cart_product.id_cart FULL
OUTER JOIN 6f45e_customer ON 6f45e_orders.id_customer = 6f45e_customer.id_customer FULL
OUTER JOIN 6f45e_product ON 6f45e_cart_product.id_product = 6f45e_product.id_product FULL
OUTER JOIN 6f45e_address ON 6f45e_orders.id_address_delivery = 6f45e_address.id_address FULL
OUTER JOIN 6f45e_preferred_delivery_time ON 6f45e_preferred_delivery_time.id_cart = 6f45e_orders.id_cart FULL
OUTER JOIN 6f45e_message ON 6f45e_message.id_order = 6f45e_orders.id_order
WHERE
6f45e_cart_product.quantity > 0
AND 6f45e_orders.current_state != 5
AND 6f45e_orders.current_state != 6
Comment