Hey! There are a few types of JOIN available to us in SQLite and PostgreSQL.

For the most part we're going to be using the same two or three different types: INNER JOIN (what we've been using until now, also called just JOIN); LEFT JOIN, and RIGHT JOIN (in PostgreSQL, more on that later!).

In the e-book I've put a couple links to some excellent explanations and visual representations of JOINs that I think you'll find very useful.

Check it out here: https://pysql.tecladocode.com/section04/lectures/18_types_of_join/

If you have any questions, let me know!

Kind regards,

Jose and the Teclado team