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