SQL Inner Join is for selecting only those rows from selected tablese where there is a matching value available. Inner join is the default join of SQL, that means if we don't use “Inner Join” we can simply use “Join”. Join also refers to Inner Join.
Lets cosider the example of our items and orders table. If we user inner join on these two tables, we will retrieve all those items that have been ordered.