mysql inner join and join code example

Example 1: only join in sql

They are functionally equivalent, but INNER JOIN can be 
a bit clearer to read, especially if the query has 
other join types (i.e. LEFT or RIGHT or CROSS) 
included in it.

Example 2: inner join mysql

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