Inner Join: Combining Data from Multiple Tables

The join used to club columns from one table with the columns of another table on the basis of common columns is called an 'inner join'. An inner join returns only matching rows from both tables, effectively combining the columns from both tables where the values in the common column(s) are identical.