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

13 votes198 views2 answers
Display users in mysql
SQL
0 vote203 views1 answer
How to fix mysql stop unexpectedly
SQL
0 vote201 views1 answer
Mysql group by derived column
SQL
1 vote217 views1 answer
Decalre temp table sql
SQL
0 vote219 views2 answers
How do I install microsoft SQL on my Mac?
SQL
0 vote206 views1 answer
Call function sql oracle
SQL
5 votes206 views4 answers
Sql check
SQL
0 vote218 views2 answers
Mysql updating multiple column values from array variable
SQL
0 vote224 views1 answer
Uncheck constraints and delete from table
SQL
0 vote220 views1 answer
Mysql persistence.xml
SQL