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 vote341 views1 answer
How to put value in variable mysql
SQL
1 vote301 views2 answers
Select only columns that are not empty oracle sql
SQL
0 vote312 views1 answer
How to select an index in oracle sql
SQL
1 vote323 views2 answers
Mysql switch case
SQL
1 vote321 views4 answers
Psql check tables command
SQL
0 vote357 views1 answer
Get substract count sql
SQL
8 votes324 views1 answer
Ltrim sql
SQL
1 vote305 views1 answer
ALL_TAB_PARTITIONS
SQL
18 votes303 views3 answers
Mysql current date
SQL
3 votes287 views2 answers
Oracle sql truncate table
SQL