I don't understand the difference between the JOIN command to the INNER JOIN command? Is it only two different ways to get the s

Answer 1

You can have either a left, right, inner or outer JOIN, depending on your exact need.

Take a look at a list of all possible JOINs:
https://www.w3schools.com/sql/sql_join.asp