Course Content
Intermediate SQL
2. Nested Subqueries
4. Left, Right, and Inner Joins
Intermediate SQL
INNER JOIN
INNER JOIN
is a join that will join only those records from two tables that contain the same values in the column being joined. It will be easier to understand on the gif. Please, watch it.

Let's take a look at the syntax.
In this section, we are going to work with the product
database. It contains the following two tables: product
, and price
. Let's take a look at them closer and learn their connections.
Let's look at the first table - product
.

Let's look at the second table - price
.

Note
INNER JOIN
andJOIN
have the same functionality in SQL and can be used interchangeably to join tables based on a specified condition.
It is time to practice!
Task
- You need to retrieve the names (
name
column from theproduct
table); - Retrieve the price (
price
column fromprice
table) of the products whose price exceeds $10; - For it you have to join these tables using the
INNER JOIN
byproduct_id
column; - Please start with the
product
table and then join theprice
table.
Everything was clear?
Section 4. Chapter 1