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 vote194 views1 answer
Local pg_sql to heroku pg_sql
SQL
0 vote155 views2 answers
Mysql slave status
SQL
0 vote119 views1 answer
Insert and initialize a SQL column with value dependent on another column data
SQL
18 votes135 views2 answers
How to get all the tables displayed in oracle
SQL
13 votes179 views2 answers
Sql join 3 tables
SQL
0 vote200 views1 answer
Sql today at midnight
SQL
1 vote180 views1 answer
Mysql column start with string
SQL
24 votes174 views4 answers
Postgres delete database
SQL
7 votes168 views1 answer
Postgres base size
SQL
0 vote183 views1 answer
SQLServerException.makeFromDatabaseError
SQL