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 vote139 views1 answer
How to query without duplicate rows in sql
SQL
3 votes198 views1 answer
Mysql group_concat distinct
SQL
0 vote131 views1 answer
Mysql_error replacement
SQL
0 vote136 views1 answer
Create table database in psql
SQL
0 vote137 views1 answer
List all functions and procedures in postgres query
SQL
0 vote90 views1 answer
Procedures and functions in pl/sql
SQL
1 vote132 views1 answer
Sqlite check if row exists
SQL
5 votes138 views3 answers
Truncate function in sql oracle
SQL
5 votes156 views1 answer
Oracle columns in all_tables
SQL
1 vote142 views1 answer
How to print longest name in sql
SQL