inner join keyword

SQL INNER JOIN is almost the same as the normal join. But the INNER JOIN will only list those rows which have at least one matching value from both tables.

SQL INNER JOIN Syntax