Join vs union

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 views2 answers
Reseed sql identity
SQL
0 vote179 views1 answer
Sql server obtener nombre sin espacios en blanco
SQL
36 votes302 views6 answers
Change column data type sql
SQL
3 votes248 views1 answer
Query less than datetime sql
SQL
2 votes178 views1 answer
Mysql query unique column
SQL
0 vote193 views1 answer
Declarative base sqlalchemy
SQL
7 votes280 views2 answers
Sql empty table
SQL
41 votes274 views6 answers
Alter table add column in SQL Server
SQL
2 votes207 views5 answers
Tablespace ORACLE
SQL
0 vote254 views1 answer
Mac os zsh: command not found: mysql
SQL