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

8 votes188 views3 answers
Alter user root mysql
SQL
10 votes161 views2 answers
Sql where clause multiple values
SQL
1 vote198 views1 answer
ORACLE RIGHT TWO DIGITS
SQL
1 vote190 views1 answer
Oracle rolling back transactions
SQL
-1 vote149 views2 answers
On delete set default sql server
SQL
1 vote194 views1 answer
Sql dcl
SQL
1 vote179 views1 answer
Sql server select rows by distinct column
SQL
0 vote189 views1 answer
Sql server udf performance
SQL
6 votes197 views2 answers
Psql load dump
SQL
0 vote231 views1 answer
Sql anywhere create procedure
SQL