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

10 votes279 views4 answers
Fetch first 5 characters of the string in sql
SQL
0 vote295 views1 answer
Suse status MySQL
SQL
0 vote305 views1 answer
Oracle swap partition
SQL
0 vote289 views1 answer
Sql select max value for each group
SQL
6 votes281 views1 answer
What is where clause in sql
SQL
21 votes287 views4 answers
Oracle add column
SQL
60 votes473 views6 answers
Add column in sql
SQL
0 vote271 views2 answers
Mysql get routine parameter list
SQL
0 vote263 views2 answers
Sql select inside select
SQL
0 vote290 views1 answer
Power bi union columns
SQL