INNER JOIN

INNER JOIN — Returns rows when there is at least one match in both tables.

INNER JOIN

SELECT *
FROM table1
INNER JOIN table2
ON table1.column_name = table2.column_name;