course content

Course Content

Intermediate SQL


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.



INNER JOIN and JOIN have the same functionality in SQL and can be used interchangeably to join tables based on a specified condition.

It is time to practice!


  1. You need to retrieve the names (name column from the product table);
  2. Retrieve the price (price column from price table) of the products whose price exceeds $10;
  3. For it you have to join these tables using the INNER JOIN by product_id column;
  4. Please start with the product table and then join the price table.

Everything was clear?

Section 4. Chapter 1
toggle bottom row