difference between join and innerjoin mysql code example
Example: 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.