Oracle SQL & PL/SQL: SQL Inner Join

SQL Inner Join Inner joins (the typical join operation, which uses some comparison operator like = or ). These include equi-joins and natural joins. Inner joins use a comparison operator to match rows from two tables based on the values in common columns

sql-plsql.blogspot.com