difference between join and inner join sql server 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.