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

1 vote318 views1 answer
Access the postgres psql
SQL
2 votes291 views1 answer
Convert series number to date in sql
SQL
-1 vote308 views1 answer
Mysql #1064 error
SQL
0 vote320 views1 answer
Oracle temporary table
SQL
0 vote321 views1 answer
Convert polygon to text in mysql
SQL
7 votes338 views6 answers
Mysql group concat
SQL
0 vote304 views1 answer
Create new table pl sql
SQL
8 votes323 views2 answers
Oracle auto increment primary key
SQL
0 vote366 views1 answer
Eliminate zero from integer mysql
SQL
0 vote320 views1 answer
Update All tables COLLATE DATABASE_DEFAULT
SQL