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 vote245 views1 answer
Sql cheetsheet
SQL
8 votes199 views2 answers
Replace string value in sql
SQL
0 vote196 views1 answer
Java sql insert return id
SQL
0 vote197 views1 answer
Sql offfset
SQL
0 vote199 views1 answer
How change the field place in mysql
SQL
-1 vote194 views1 answer
How to switch user in mysql
SQL
2 votes198 views1 answer
Set boolean flasksql
SQL
0 vote194 views1 answer
Sql counter column
SQL
20 votes207 views6 answers
Mysql reset auto increment
SQL
0 vote192 views1 answer
How to add boolean column in postgresql
SQL