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

2 votes190 views1 answer
Oracle sql drop column if exists
SQL
0 vote203 views1 answer
Sql mod even odd
SQL
0 vote205 views1 answer
Codigo crear tablas sql server
SQL
1 vote172 views1 answer
Login to database mysql terminal
SQL
0 vote181 views1 answer
Como saber si tengo mysql instalado
SQL
0 vote198 views1 answer
Sql cmd no truncate
SQL
0 vote233 views1 answer
Tsql cte in a transaction
SQL
0 vote164 views1 answer
How to create an SQL save method in ruby
SQL
1 vote177 views2 answers
Sql select only first occurrence
SQL
0 vote193 views1 answer
Mysql average from two table
SQL