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

2 votes276 views1 answer
SELECT INTO
SQL
1 vote284 views1 answer
Trim leading zeros in sql
SQL
1 vote252 views1 answer
Oracle lowercase
SQL
0 vote319 views2 answers
Suse Linux restart MySQL
SQL
51 votes592 views6 answers
Installing mysql on ubuntu
SQL
-1 vote268 views3 answers
Psql get last rows
SQL
1 vote264 views1 answer
Create index concurrently postgres
SQL
9 votes278 views4 answers
SQL Date Format
SQL
0 vote271 views1 answer
Mysql disable query caching
SQL
9 votes262 views2 answers
Get first 3 letters in sql
SQL