Session Ready
Exercise

Full join (2)

You'll now investigate a similar exercise to the last one, but this time focused on using a table with more records on the left than the right. You'll work with the languages and countries tables.

Begin with a full join with languages on the left and countries on the right. Appropriate fields have been selected for you again here.

Instructions 1/3
undefined XP
  • 1
    • Choose records in which countries.name starts with the capital letter 'V' or is NULL.
    • Arrange by countries.name in ascending order to more clearly see the results.
    • 2
      • Repeat the same query as above but use a left join instead of a full join. Note what has changed compared to the full join result!
    • 3
      • Repeat once more, but use an inner join instead of a left join. Note what has changed compared to the full join and left join results.