Give a brief explanation of how the JOIN operator is used, including sample syntax. Also explain how inner joins differ from outer joins and give an example of how their results might be different. Provide basic references.