Self Join

Every join we have covered so far combines rows from two different tables. But some relationships exist within a single table: an artist managed by another artist, two users who follow each other, two tracks on the same album with the same duration.

A self join handles this by joining a table to itself using two different aliases.