DataCamp

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.

1
Choose records in which countries.name starts with the capital letter 'V' or is NULL. Lastly, 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.

Exercise

Full join (2)

Instructions 1/3