We refer to a join as a self-join when…
we are using left and right join together
we are joining more than 2 tables
we are joining table to itself
when joining a table and its view