Insert

• INSERT INTO is the ANSI standard, but the INTO here is optional in mysql, SQL server and teradata

Join, union

Join

• is used in order to combine two or more tables based on common property (ON clause)
• horizontal columns merge

Union

• is used when there is a need to produce a conjunction/combined result of two SELECT statements.
• vertical rows merge

Reference

• eBook
• w3 schools