1. Learn
    2. /
  2. Courses
    3. /
  3. SQL for Joining Data

Exercise

Left Join

Now you'll explore the differences between performing an inner join and a left join using the cities and countries tables.

You'll begin by performing an inner join with the cities table on the left and the countries table on the right. Remember to alias the name of the city field as city and the name of the country field as country.

You will then change the query to a left join. Take note of how many records are in each query here!

Instructions 1/2

undefined XP
  • 1

    Fill in the code based on the instructions in the code comments to complete the inner join. Note how many records are in the result of the join in the query result.

  • 2

    Change the code to perform a LEFT JOIN instead of an INNER JOIN. After executing this query, note how many records the query result contains.