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

0 vote200 views1 answer
Sum values by month mariadb
SQL
18 votes218 views3 answers
Mysql add column default value
SQL
2 votes207 views1 answer
Where clause for child record apex
SQL
0 vote197 views1 answer
Sql offfset
SQL
1 vote193 views1 answer
Mysql best tutorial for beginners
SQL
0 vote205 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL
-1 vote201 views3 answers
MySQL shutdown unexpectedly
SQL
1 vote228 views1 answer
Raw query must include primary key
SQL
3 votes246 views1 answer
Oracle detect invalid password
SQL
3 votes193 views3 answers
Remove all spaces from string sql
SQL