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

17 votes103 views4 answers
Show tables sql server
SQL
0 vote131 views1 answer
How to pass list as parameter in SQL query
SQL
0 vote106 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = blog and table_name = migrations and table_type = 'BASE TABL
SQL
-1 vote109 views3 answers
Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
0 vote102 views1 answer
Sql change primary key to composite key
SQL
0 vote102 views3 answers
ChAnge TABLE name apex oracle
SQL
4 votes110 views2 answers
Show all database inside postgresql
SQL
0 vote104 views1 answer
Symfony\Component\Debug\Exception\FatalThrowableError : Class 'Doctrine\DBAL\Driver\PDOSqlite\Driver' not found
SQL
2 votes154 views3 answers
Mysql cheat sheet
SQL
4 votes129 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL