Skip to main content

inner join keyword

SQL 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

SELECT column_name(s) FROM First_table_name INNER JOIN Second_table_name ON First_table_name.column_name= Second_table_name.column_name

Consider the following table for this exercise

Users