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 vote192 views2 answers
Get day in sql
SQL
0 vote198 views1 answer
Jooq replace
SQL
1 vote220 views1 answer
Mysql datetime with timezone offset
SQL
0 vote203 views1 answer
Mysql count number of occurrences in a column
SQL
21 votes213 views1 answer
Cheatsheet for sql
SQL
0 vote206 views1 answer
Tsql cmd exec script from file
SQL
4 votes197 views4 answers
Sqlite describe table
SQL
0 vote212 views1 answer
Mysql where in maintain order
SQL
1 vote209 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL
5 votes213 views2 answers
Sql number columns
SQL