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 vote268 views1 answer
Db format in quotation
SQL
0 vote268 views1 answer
Sql server concat null
SQL
0 vote263 views1 answer
Sql create text column limited values
SQL
0 vote280 views1 answer
Openquery update linked server
SQL
0 vote254 views1 answer
Delete double on SQL with multiple primary keys
SQL
5 votes290 views2 answers
Mysql dump mysql db cli
SQL
0 vote279 views1 answer
Mysql update from select on same table
SQL
0 vote276 views1 answer
Postgresql get diff between two dates in Months
SQL
7 votes263 views1 answer
Set sequence value oracle
SQL
1 vote282 views1 answer
Sql view where tables have same column name combine results
SQL