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

10 votes152 views1 answer
Oracle dependency
SQL
0 vote172 views1 answer
Drop column from local database postgres pgadmin
SQL
0 vote164 views1 answer
Sql find leading space
SQL
6 votes163 views3 answers
Error Code: 1055. Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mydb.term.year' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote158 views2 answers
Show slave status mysql
SQL
0 vote164 views2 answers
How to relationship query two different tables in MySQL
SQL
0 vote159 views1 answer
Mysql add to value
SQL
0 vote176 views1 answer
Sql query to get column names and data types in sql server
SQL
3 votes179 views2 answers
Truncate table
SQL
0 vote221 views1 answer
Sql commands in android
SQL