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 vote206 views1 answer
Module operator in oracle sql
SQL
13 votes216 views3 answers
List all the tables in sql
SQL
3 votes218 views1 answer
Oracle user quota on tablespace
SQL
13 votes190 views4 answers
Mysql select last 10 rows
SQL
15 votes196 views4 answers
Create table if not exists sql
SQL
0 vote242 views1 answer
Download mysql database to excel in android studio
SQL
0 vote212 views1 answer
Command line mysql xampp
SQL
7 votes221 views1 answer
Sql pagination oracle
SQL
0 vote211 views1 answer
How to alter length character varying postgres
SQL
0 vote219 views1 answer
Add two days to current date in sql when creating tables
SQL