SQL Inner Join

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?

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

SELECT * FROM table1 INNER JOIN table2 ON table1.table2_id = table2.id INNER JOIN table3 ON