What's the difference between JOIN and INNER JOIN?

There's no difference, JOIN is short for INNER JOINJOIN connects rows whether they match or not

There's no difference, JOIN is short for INNER JOIN.