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 vote261 views2 answers
Plsql regex match whole word
SQL
0 vote246 views1 answer
Data types mysql vs postgresql
SQL
0 vote249 views1 answer
Change schema of all tables postgres
SQL
0 vote276 views1 answer
Sql injection payload list github
SQL
1 vote272 views2 answers
Foreign key set 0
SQL
3 votes294 views2 answers
Synonym oracle
SQL
2 votes274 views1 answer
Where clause for child record apex
SQL
0 vote275 views1 answer
Error code 1241 mysql
SQL
24 votes275 views6 answers
Alter table name sql
SQL
1 vote240 views1 answer
Clear screen command in psql
SQL