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 vote120 views1 answer
Complete date is 1 year or not sql server
SQL
1 vote128 views1 answer
Sql select row with max date
SQL
0 vote169 views1 answer
Uncaught PDOException: SQLSTATE[HY000] [1698]
SQL
2 votes123 views1 answer
Match in sql server
SQL
8 votes133 views1 answer
Oracle current date plus 1 month
SQL
0 vote81 views1 answer
Ms sql print more than 1 variable
SQL
12 votes140 views6 answers
Between in sql
SQL
0 vote132 views1 answer
Oracle webcenter content search enginer
SQL
1 vote131 views1 answer
Wordpress change http to https phpmyadmin
SQL
0 vote114 views1 answer
Faire une recherche par liste de mot clé sql
SQL