Join allow you to view data from related tables in a single result set. to retrieve data from multiple tables the SQL server allows you to apply join.
An Inner join retrieve records from multiple join table by using comparison operator on a common column. when an inner join is applied, only rows with the values satisfying the join condition in the common column are displayed. Rows in both table that don't satisfy the join condition are not displayed.
Note An inner join is default join, therefore you can also apply an inner join by using the JOIN keyword. in addition you can use Inner Join keyword.
Reference Link :-
MSDN-[Inner JOIN][
^]