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 votes267 views1 answer
Get first n letter of department name in sql
SQL
22 votes260 views2 answers
Mysql show all tables
SQL
104 votes435 views2 answers
Like in mysql
SQL
0 vote276 views1 answer
How to insert a uniqueidentifier in sql
SQL
-1 vote262 views1 answer
Ssql to lowercqse
SQL
-1 vote236 views1 answer
Mysql if example
SQL
0 vote315 views1 answer
Compress sql file database ubuntu
SQL
0 vote276 views1 answer
Mysql aspas simples
SQL
0 vote278 views1 answer
Find how many table doesn't contain column in mysql
SQL
12 votes273 views4 answers
Psql command not found
SQL