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 vote246 views1 answer
Sqlite3_open_v2
SQL
0 vote223 views1 answer
Use where instead of join
SQL
3 votes215 views4 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client vs code
SQL
13 votes213 views2 answers
Display users in mysql
SQL
0 vote244 views1 answer
Mysql select random rows large table
SQL
0 vote234 views1 answer
Get all employee of salary if more than in sql
SQL
2 votes217 views1 answer
Sql ignore accents
SQL
2 votes229 views1 answer
Oracle kill job by sid
SQL
0 vote221 views1 answer
Postgres full text search example
SQL
1 vote238 views1 answer
Sql restore backup query
SQL