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

0 vote248 views1 answer
Codeigniter 3 get best-selling products
SQL
22 votes233 views3 answers
Sql cheat sheet
SQL
0 vote219 views1 answer
Get all employees if name ends with in sql
SQL
1 vote230 views1 answer
Primary key reset in SQL database
SQL
0 vote243 views1 answer
Sql server roles and users
SQL
0 vote237 views1 answer
Sql show all users
SQL
1 vote237 views1 answer
Mysql query where in select
SQL
1 vote236 views1 answer
Find difference in dates sql
SQL
0 vote218 views1 answer
Strat with in sql
SQL
0 vote227 views1 answer
Mysql money value
SQL