MySQL shows me that there is an error

SQL
1

Hello, I am doing the SQL course, and I am in the Inner Joins session, I have been working very well with all the examples, but something is happening, that I do not know how to correct it, every time I want to execute this query:

SELECT *
FROM orders
JOIN customers
ON orders.customer_id = customers.customer_id

or

SELECT order_id, o.customer_id, first_name, last_name
FROM orders o
JOIN customers c
ON o.customer_id = c.customer_id

it shows me that there is an error.

image
image1534×1009 203 KB

Could anyone help me, Thanks

2

Your default schema seems to be sql_inventory. Change that to sql_store or issue a USE sql_inventory; statement before querying the data.

1 Like
3

Thank you very much for the recommendation, I used USE sql_store; and everything is already working fine.