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

1 vote235 views1 answer
Sql server list locks
SQL
0 vote236 views2 answers
Script all indexes in a database
SQL
0 vote214 views1 answer
How many columns can be used for creating index?
SQL
0 vote224 views2 answers
Sql join on wildcard
SQL
0 vote201 views1 answer
Mysql create table columns with spaces
SQL
0 vote239 views1 answer
Insensitive case match sqlalchemy
SQL
0 vote238 views1 answer
Sql log file inof
SQL
7 votes253 views1 answer
Oracle alter sequence restart start with
SQL
2 votes234 views1 answer
How to show the whole table in sql
SQL
0 vote230 views1 answer
Mysql read row
SQL