mysql - SQL连接一些表

Question

我有这四个表:

用户(userId,username,password)

书籍(id,title,author,isbn,cost)

Orders(orderID,orderDate,userId)(manyToOne 到 User，oneToMany 到 OrderItem)

OrderItem(id,quantity,totalPrice,Book_id, order_orderID)(manyToOne 到 Order，manyToOne 到 Book)

我要检索 title , cost , author , orderID , Quantity 其中 userID=1

这是我的查询:

SELECT
  book.title,
  book.cost,
  book.author,
  orders.orderDate,
  orderitem.quantity,
  orderitem.totalPrice
FROM book
  JOIN orderitem ON book.id = orderitem.id
  JOIN orders ON orders.orderID = orderitem.order_orderID WHERE user_id=1;

但是这个查询没有结果!

Answer 1

 SELECT
      book.title,
      book.cost,
      book.author,
      orders.orderDate,
      orderitem.quantity,
      orderitem.totalPrice
    FROM book
      INNER JOIN orderitem ON book.id = orderitem.Book_id
      INNER JOIN orders ON orders.orderID = orderitem.order_orderID 
    WHERE user_id = 1;