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 vote169 views1 answer
Select in select sql
SQL
0 vote174 views1 answer
Write a query to peint the pattern P(20)
SQL
1 vote171 views1 answer
Mysql count words
SQL
8 votes180 views1 answer
Script to add datafile to tablespace
SQL
0 vote176 views1 answer
Excel export from sql using python
SQL
12 votes257 views4 answers
How to drop all tables in postgresql
SQL
2 votes171 views1 answer
Mysql sql add created updated timestamp to existing table
SQL
0 vote180 views1 answer
Mysql average from two table
SQL
0 vote231 views1 answer
Inner join distinct
SQL
4 votes163 views3 answers
Order by value mysql
SQL