DEV Community

Astrid
Astrid

Posted on • Originally published at developerastrid.com

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/

Discussion (0)