Left Join & Right 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!