mysql - 我的 sql 第 12 行或“order ON order-user_id = user.id”附近出现错误。有什么想法吗？谢谢

Question

SELECT order.date,
   vehicle.year, 
   vehicle.make, 
   vehicle.model, 
   SUM(part.price * order_details.quantity) AS price, 
   order.paid 
FROM vehicle
INNER JOIN user 
   ON user.id = vehicle.user_id
INNER JOIN order 
   ON order.user_id = user.id
INNER JOIN order_details 
   ON order_details.order_id = order.id
INNER JOIN part 
   ON part.id = order_details.part_id

Answer 1

ORDER 是大多数 SQL 实现中的保留关键字；您可能需要使用反引号来分隔表名。

SELECT `order`.date,
   vehicle.year, 
   vehicle.make, 
   vehicle.model, 
   SUM(part.price * order_details.quantity) AS price, 
   `order`.paid 
FROM vehicle
INNER JOIN user 
   ON user.id = vehicle.user_id
INNER JOIN `order` 
   ON `order`.user_id = user.id
INNER JOIN order_details 
   ON order_details.order_id = `order`.id
INNER JOIN part 
   ON part.id = order_details.part_id