Jump to content

Export zamówienia z kosztem wysyłki (SQL Manager)


ProExCurator

Recommended Posts

Hej. Po raz pierwszy próbuje coś wyeksportować przy użyciu SQL Managera i jeszcze nie do końca wiem jak to działa. Próbuje wyeksportować zamówienia ze szczegółami i w szczególności z kosztem wysyłki. To jak próbuje to zrobić (ale nie wychodzi):

SELECT d.id_order, os.name AS state, d.product_name, d.product_reference, d.product_price, d.product_quantity, o.payment, o.date_upd, CONCAT_WS(' ', g.firstname, g.lastname) AS customer, gl.name AS group_name, price
    FROM ps_order_detail d
    LEFT JOIN ps_orders o ON (d.id_order= o.id_order)
    LEFT JOIN ps_customer g ON (o.id_customer = g.id_customer)
    LEFT JOIN ps_group_lang gl ON (g.id_default_group = gl.id_group) AND gl.name LIKE 'club%'
    LEFT JOIN ps_order_state_lang os ON (o.current_state = os.id_order_state)
    LEFT JOIN ps_delivery
    WHERE os.id_lang = 1

Ktoś może pomóc prawidłowo to skonstruować?

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...