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

6 votes108 views1 answer
Phpmyadmin reset root password
SQL
3 votes129 views1 answer
Oracle undo tablespace schema
SQL
9 votes118 views2 answers
Nosql databases
SQL
0 vote116 views1 answer
Mysql Error Code: 1005
SQL
0 vote128 views2 answers
Mysql missin expression near on
SQL
0 vote115 views1 answer
Can't connect to postgresql mac os
SQL
1 vote127 views1 answer
Postgres select as csv
SQL
8 votes123 views2 answers
Oracle undo usage
SQL
0 vote132 views1 answer
Recently updated stored procedure in sql server
SQL
3 votes108 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL