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

1 vote208 views1 answer
Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1
SQL
37 votes348 views3 answers
Sql check duplicate value in column
SQL
0 vote210 views1 answer
No suitable driver found for sqlite
SQL
2 votes215 views1 answer
Laravel sql String
SQL
0 vote232 views1 answer
Normalization in database
SQL
0 vote227 views1 answer
Which lock mode is not available in sql
SQL
6 votes222 views2 answers
Sql query to get the number of rows in a table
SQL
0 vote213 views1 answer
Oracle index hint
SQL
2 votes236 views2 answers
Oracle create table if not exists
SQL
0 vote219 views1 answer
Sql remove decimal places
SQL