course content

Course Content

Intermediate SQL

RIGHT JOINRIGHT JOIN

RIGHT JOIN returns all records from the right table and matching records from the left table. For records with no matching, it completes the fields with NULL. Let's look at the gif for a better understanding.

Let's take a look at the syntax.

Task

  1. You need to get a list of all prices (the price column from the price table);
  2. Display the name of the products (name column from the product table) for the prices for which they are available;
  3. For it you have to join these tables by the product_id column.

Everything was clear?

Section 4. Chapter 4
toggle bottom row