The overlap is known as the Intersection, and it represents all common/matched rows from both the Tables.
INNER JOIN
got its name Since it retrieves all the rows from INSIDE the Intersection and
OUTER JOIN
because it retrieves rows from Inside and Outside of the Intersection (Depending on the type of JOIN
)