无法获得批发价格和客户名称
无法获得批发价格和客户名称
提问于 2017-09-05 01:45:17
我正试图为这个“产品销售”报告提取批发价和客户名称，但我不明白为什么我没有得到结果。此SQL显示结果，直到“支付作为"Medio de Pago”。
SELECT w.id_warehouse AS "Warehouse ID", w.name AS "Warehouse Name", o.id_order AS "Order ID", od.product_id AS "Product ID",od.product_attribute_id AS "Combination ID", od.product_name AS "Product Name", od.product_quantity AS Quantity, date_add AS "Order Date", id_customer AS "Customer ID", payment AS "Medio de Pago", p.wholesale_price AS "Costo de Ventas", c.firstname AS "Nombre"
FROM ps_order_detail od
INNER JOIN ps_orders o ON (o.id_order = od.id_order)
LEFT JOIN ps_warehouse w ON (w.id_warehouse = od.id_warehouse)
JOIN ps_product p ON (p.id_product = od.product_id)
JOIN ps_customer c ON (c.id_customer = o.id_customer)
WHERE o.date_add > DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 30 DAY),'%Y-%m-%d')
ORDER BY date_add ASC, o.id_order ASC, w.id_warehouse ASC;非常感谢你的帮助。我真不知道什么不管用。
回答 1
Stack Overflow用户
回答已采纳
发布于 2017-09-05 06:19:01
请试一试：
SELECT w.id_warehouse AS "Warehouse ID", w.name AS "Warehouse Name", o.id_order AS "Order ID", od.product_id AS "Product ID",od.product_attribute_id AS "Combination ID", od.product_name AS "Product Name", od.product_quantity AS Quantity, o.date_add AS "Order Date", c.id_customer AS "Customer ID", payment AS "Medio de Pago", p.wholesale_price AS "Costo de Ventas", c.firstname AS "Nombre"
FROM ps_order_detail od
INNER JOIN ps_orders o ON (o.id_order = od.id_order)
LEFT JOIN ps_warehouse w ON (w.id_warehouse = od.id_warehouse)
JOIN ps_product p ON (p.id_product = od.product_id)
JOIN ps_customer c ON (c.id_customer = o.id_customer)
WHERE o.date_add > DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 30 DAY),'%Y-%m-%d')
ORDER BY o.date_add ASC, o.id_order ASC, w.id_warehouse ASC;页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/46045908
复制相关文章
相似问题
腾讯云开发者
