Complete SQL Mastery Problem

1

In the section retrieving data from multiple tables, 11 Natural Joins video, I used exactly the same code as Mosh :

SELECT
o.order_id,
c.first_name
From orders o
Join customers c
USING (customer_id)
Join shippers sh
USING (shipper_id)

But it’s giving me an error

0 7 10:17:51 SELECT o.order_id, c.first_name From orders o Join customers c USING (customer_id) Join shippers sh USING (shipper_id) LIMIT 0, 2000 Error Code: 1046. No database selected Select the default DB to be used by double-clicking its name in the SCHEMAS list in the sidebar. 0.000 sec

Does anyone know the problem root?

Many thanks.

2

Try to add this before your query:

USE sql_store;

SELECT o.order_id, c.first_name
From orders o
Join customers c
USING (customer_id)
Join shippers sh
USING (shipper_id)
3

Ok thank you I will try

4

it’s simply you have not selected any database to run your code.