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

2 votes271 views2 answers
Null column to 0 in mysql
SQL
0 vote262 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
11 votes269 views1 answer
Oracle export view ddl
SQL
0 vote230 views1 answer
Sql convert datetime to year
SQL
1 vote258 views1 answer
Trim leading zeros in sql
SQL
0 vote224 views1 answer
Database get 10 user aleatory
SQL
6 votes223 views1 answer
Postgresql get year
SQL
1 vote229 views1 answer
How to truncate a table in databse
SQL
0 vote252 views1 answer
Tsql delete all rows
SQL
0 vote237 views1 answer
Prepared statement mysql java delete selected rows
SQL