How to use self-joins, natural joins and outer joins in SQL

This article introduces self-join, natural join, and outer join, including their meanings and usage. It introduces how to use table aliases and how to use aggregation functions on the joined tables.

Link to the original article: https://www.developerastrid.com/en/sql/sql-joins/