SQL INNER JOIN

SQL INNER JOIN Keyword
The INNER JOIN keyword selects all rows from both tables as long as there is a match between the columns in both tables.


SQL INNER JOIN Syntax
SELECT column_name(s)
FROM table1
INNER JOIN table2
ON table1.column_name=table2.column_name;
or:

SELECT column_name(s)
FROM table1
JOIN table2
ON table1.column_name=table2.column_name;