a join where the WHERE clause selects rows where some shared attribute has an equal value

an equi-join that projects away duplicated attributes

a short hand for JOIN USING which specifies that the join should be on all of the commonly named columns

(SQL) Join of two tables with the intersection of their schemes used as join attributes. jointypes.php

links tables by selecting only the rows with common values in their common attributes

a join in which the redundant logic components generated by the join are removed.

join statement that compares the common columns of both tables with each other. One should check whether common columns exist in both tables before doing a natural join. Example: SELECT DEPT_NAME, EMPLOYEE_NAME FROM DEPT NATURAL JOIN EMPLOYEE;