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

0 vote280 views1 answer
Sql values not in another table
SQL
0 vote269 views2 answers
Php convert dbf to mysql
SQL
0 vote376 views2 answers
Sqlalchemy default value for column
SQL
0 vote276 views1 answer
Convert int to varchar sql
SQL
0 vote295 views1 answer
Consulta alias con inner join
SQL
1 vote275 views1 answer
Get the User Name and Domain Name from an Email Address
SQL
0 vote307 views1 answer
Sql with example
SQL
0 vote280 views2 answers
SQL BULK INSERT
SQL
0 vote303 views1 answer
Postgresql list extensions
SQL
0 vote284 views1 answer
Mysql timediff
SQL