SQL Inner Join

The INNER JOIN keyword selects all rows from both the tables as long as the condition is satisfied. This keyword will create the result-set by combining all rows from both the tables where the condition satisfies i.e value of the common field will be the same. 

Syntax: 

SELECT table1.column1,table1.column2,table2.column1,....

FROM table1 

INNER JOIN table2

ON table1.matching_column = table2.matching_column;

Note:

table1: First table.

table2: Second table

matching_column: Column common to both the tables.