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 vote334 views1 answer
Get relation data in mysql using query to excel
SQL
0 vote335 views1 answer
Postgresql interview questions
SQL
2 votes311 views1 answer
Mysql list users on ubuntu
SQL
0 vote324 views1 answer
Update if else mysql
SQL
0 vote353 views1 answer
Tsql table column constraint must be uppercase
SQL
1 vote322 views1 answer
Sql select where id not exists in another table
SQL
0 vote322 views1 answer
Add alternate add column sql
SQL
0 vote330 views1 answer
How to use query in nosql
SQL
0 vote391 views1 answer
Tsql cte in a transaction
SQL
7 votes324 views1 answer
Sql management studio display line numbers
SQL