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 vote173 views1 answer
T sql cursor tr
SQL
7 votes179 views1 answer
Connect mysql docker
SQL
1 vote247 views1 answer
Show databases mysql docker
SQL
1 vote175 views1 answer
Spark sql concatenate string and int
SQL
0 vote176 views1 answer
See Foreign Key
SQL
1 vote195 views1 answer
Oracle activate job
SQL
0 vote184 views1 answer
Less than date query sqlachemy
SQL
9 votes191 views3 answers
Import DB through mysql console
SQL
0 vote179 views1 answer
Oracle exchange subpartition
SQL
0 vote150 views0 answer
SQL