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

48 votes218 views3 answers
Psql create database
SQL
0 vote191 views1 answer
Import sql dump into postgresql database
SQL
0 vote136 views1 answer
Trigger vérifier stock
SQL
5 votes172 views4 answers
Mysql on duplicate key update
SQL
0 vote95 views1 answer
Hangfire clean script
SQL
1 vote142 views1 answer
Update from select oracle
SQL
1 vote86 views1 answer
Mysql collation
SQL
0 vote125 views1 answer
TSQL Code Snippet For Optimized Sales Query
SQL
0 vote163 views1 answer
Oracle create package specification
SQL
0 vote134 views1 answer
Sql find gaps in date ranges
SQL