Question: what is the difference between inner join and join?
Answer: JOIN and INNER JOIN are the same, the inner keyword is optional as all joins are considered to be inner joins unless otherwise specified. ... A FULL OUTER JOIN will return everything an inner join does and return all unmatched rows from each table.