MySQL Inner Join:
The MySQL Inner Join clause matches rows in one table with rows in other tables and allows you to query rows that contain columns from both tables. The inner join clause is an optional part of the SELECT statement. It appears immediately after the FROM clause.
Syntax of MySQL Inner Join:
INNER JOIN table2 ON condition1;