Self JOIN

Search:

Self JOIN

A SQL JOIN is referred to as a Self-JOIN when a database table is joined to itself.
SQL Tutorial