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

17 votes108 views3 answers
Postgresql version command
SQL
0 vote102 views1 answer
Mysql add to value
SQL
0 vote158 views1 answer
Insert query return id mysql
SQL
2 votes141 views1 answer
Oracle insert or update
SQL
0 vote115 views1 answer
T-SQL Create Trigger
SQL
0 vote113 views1 answer
New rails app with mysql
SQL
0 vote145 views1 answer
Postgres list all stored procedures query
SQL
1 vote104 views1 answer
Login to database mysql terminal
SQL
37 votes101 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL
0 vote117 views1 answer
Get initials name in sql
SQL