natural join
unlike normal join, it's not all the possible compositions of the tuples, it only contains the mutual tuples in the common attributes.
When we connect two tables, what we care about is : which attribute we choose to base on, and which tuple we choose as the results.
For the former one, we have join and natural join, and for the latter ,we have inner join, left outer join, right outer join and full outer join.