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

1 vote118 views1 answer
Oracle columns table
SQL
2 votes148 views1 answer
Sql compare strings
SQL
0 vote100 views1 answer
Mysql set variable to today's date
SQL
0 vote102 views1 answer
Postgres declare variable
SQL
2 votes111 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly.
SQL
0 vote114 views1 answer
Postgre query date
SQL
1 vote95 views1 answer
How to use a trigger to validate input data
SQL
6 votes98 views1 answer
Oracle trigger after connect
SQL
-1 vote58 views1 answer
Oracle db list usernames
SQL
0 vote99 views1 answer
Sum sqlserver
SQL