In this chapter we’ve learned 3 types of joins:
To close it let’s briefly talk about other types of SQL joins. In practice
INNER JOIN and
LEFT JOIN together cover the majority of our needs. To know other join types is beneficial In case we’re working with existing queries which we didn’t write. Plus it’s useful to know what’s possibilities SQL provides us.
RIGHT JOIN is similar to the
LEFT JOIN. The main difference is that the right table is the one that keeps all its rows in the result.
SELECT * FROM...