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

1 vote329 views1 answer
Sql padd let with zeros
SQL
15 votes484 views2 answers
Sql order by alphabetical
SQL
50 votes403 views6 answers
Sql duplicate rows
SQL
3 votes301 views4 answers
Show sql server database
SQL
0 vote377 views1 answer
Dockerfile example for Django
SQL
0 vote313 views1 answer
Where in clause tsql
SQL
0 vote327 views1 answer
Mysql terminal run sql file
SQL
11 votes341 views1 answer
Oracle view source
SQL
0 vote321 views1 answer
Alter database name script
SQL
0 vote308 views1 answer
Take sql dump in to file
SQL