hi there!
I have a question. I wrote the code as explained in the video and I cannot execute it due to error 1049: Unknown database. sql_store is the one selected and it is supposed to select the sql_inventory database products table. However, the app tells me that the database is unknown.
Many websites mention I should use the clause USE to select the database, but that would be something at the beginning. As you can see in the images, the sql_store is selected already to use.
Why I cannot execute the code? How can I fix it?
The forum does not let me upload any images because I am new. I get an error every time I upload an image. This is the code I have written:
SELECT *
FROM order_items oi
JOIN slq_inventory.products p
ON oi.product_id = p.product_id
This is the error I get:
11:13:37 SELECT * FROM order_items oi JOIN slq_inventory.products p ON oi.product_id = p.product_id LIMIT 0, 1000 Error Code: 1049. Unknown database ‘slq_inventory’ 0.000 sec
Database selected: sql_store
Name of the other database: sql_inventory
Video SQL Mastery: Join across databases at minute 1:33
MySQL Workbench version: 8.0.24 build 681332CE 64 Community
