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

7 votes295 views3 answers
Python and mysql connectivity
SQL
1 vote285 views1 answer
Mysql view command
SQL
1 vote281 views2 answers
Sql select only first occurrence
SQL
0 vote291 views1 answer
Pass array parameter to stored procedure c#
SQL
1 vote305 views2 answers
Postgres select from last 3 months
SQL
7 votes306 views2 answers
Mysql Public Key Retrieval is not allowed
SQL
0 vote302 views1 answer
Dbms_output sql developer
SQL
1 vote289 views2 answers
Datetrunc hour snowflake
SQL
2 votes318 views1 answer
Where clause for child record apex
SQL
0 vote296 views1 answer
SAP Return
SQL