Answer Posted / uchit shah

A Union and Join are similar in that they both are combining
two tables to form another table. However they do this
combining in different ways. The geometry is different.

Lets say for Table A and Table B
Union : -
|A|
-
|B|
-

Join : - -
| A | B |
- -

Union :
(1) In Union Two Rows of one table must fit onto the other
table. The Number of columns in the result table is the same
as the number in both tables. No new Columns are added.

(2) Maximum Number of rows = Sum of Number of rows in the
two tables.

Join :
(1) In Join the rows of one table may be different from the
rows of another table. The result table can contain columns
from both the first and second tables. It can contain all
the columns of first table and all the columns of second tables.

(2) Maximum Number of rows = Product of rows in two tables.

what are the drivers in mysql? : Sql dba

1059

---

Why is sharding used?

1060

---

What is the usage of sql functions?

1204

---

what are the 'mysql' command line arguments? : Sql dba

1192

---

What is the use of function in sql?

1152

---

What trigger means?

1036

---

How do you write a subquery?

1070

---

What is a primary key example?

1001

---

How do I trace sql profiler?

1044

---

What is sql mysql pl sql oracle?

1129

---

What are the types of triggers in sql?

1143

---

What does stand for in sql?

1024

---

how to get @@error and @@rowcount at the same time? : Sql dba

1082

---

Can triggers stop a dml statement from executing on a table?

1158

---

Can you inner join the same table?

1039

---