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

3 votes348 views2 answers
Sql asc
SQL
2 votes377 views1 answer
Rails execute sql
SQL
7 votes351 views3 answers
Restore postgres database from sql file
SQL
0 vote333 views1 answer
Sql counter column
SQL
0 vote336 views1 answer
Mysql select last 15 minutes
SQL
3 votes355 views1 answer
DB: in eloquent using sql
SQL
0 vote373 views1 answer
Left join vs inner join performance
SQL
45 votes420 views5 answers
Grant all privileges mysql
SQL
0 vote334 views1 answer
Select from another database
SQL
0 vote327 views1 answer
Oracle list chain steps
SQL