mysqlで内部結合

Question

SELECT
	orders.order_id,
	orders.order_date,
	customers.customer_id,
	customers.phone_number,
	products.product_name,
	products.price,
	order_details.quantity
FROM orders
INNER JOIN order_details
ON orders.order_id = order_details.order_id;
INNER JOIN customers
ON orders.customer_id = customers.customer_id;
INNER JOIN products
ON order_details.product_id = products.product_id;

mysqlで内部結合の課題です。
どこが誤りでしょうか。ご回答お願い致します。

Comments

[m.ts10806]

https://teratail.com/help/question-tips#questionTips3-1
https://teratail.com/help/question-tips#questionTips3-3
https://teratail.com/help/question-tips#questionTips3-4

Answer 1

; はSQLの終わりって意味ですから最後に1つだけに。

Comments

[Matsui]

ありがとうございます！