In the third section
Retrieving Data From Multiple Tables (01:02)
First Inner Joins video, in the end exercise, it asks to show the product_id, name, quantity etc.
But when I type out SELECT name, the name is highlighted in blue and is throwing an error.
How to show the name???
please provide more context .
FROM orders o
INNER JOIN customers c ON o.customer_id = c.customer_id
INNER JOIN order_statuses os ON o.status = os.order_status_id
Let me know wether you were asking query on Exercise…I will revert that too.