# What's Inner Join in SQL? The term join refers to the merging of rows from two or more tables based on a related column. Among the different joins available -- inner join, left join, right join and full outer join - inner join is a fundamental yet powerful feature for SQL Databases An **INNER JOIN** returns records from matching values in two or more tables being joined. Hence, the result table is created containing matching rows in all these tables # When do you need INNER JOIN? When you need to put together data from a few different tables # How to use INNER JOIN? ```sql SELECT * from table1 INNER JOIN table2 ON table1.table2_id = table2.id ``` To use multiple join statements to join more than one table at the same time ```sql SELECT * FROM table1 INNER JOIN table2 ON table1.table2_id = table2.id INNER JOIN table3 ON ```