Difference between join vs union

JOIN combines the ROWs, we will have longer rows at the end. 
We are joining the rows from two or more related tables.

UNION combines the COLUMNs, we will have longer columns at the end.
UNION combine two different query.
We are joining the columns from two or more related tables.
Can be non related tables but queries must select same column names
with same data type.

Join vs union

JOIN combines the ROWs, we will have longer rows at the end. 
We are joining the rows from two or more related tables.

UNION combines the COLUMNs, we will have longer columns at the end.
UNION combine two different query.
We are joining the columns from two or more related tables.
Can be non related tables but queries must select same
column names with same data type.

Similar codes

1 vote198 views3 answers
Mysql disable foreign keys check
SQL
0 vote206 views2 answers
Laravel: customize or extend notifications - database model
SQL
3 votes202 views3 answers
Stop mysql ubuntu
SQL
0 vote178 views1 answer
Hangfire clean script
SQL
0 vote232 views1 answer
Sql get latest of 2 datetimes
SQL
25 votes247 views6 answers
Import database mysql command line
SQL
0 vote201 views1 answer
What is delimiter in mysql
SQL
1 vote205 views1 answer
Mysql show queries running
SQL
0 vote238 views1 answer
MySQL get all previous date record
SQL
4 votes226 views3 answers
NOT NULL SQL
SQL