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 is a trigger in mysql? : Sql dba

1067

---

Is join same as left join?

977

---

What is online transaction processing (oltp)?

961

---

How to use distinct and count in sql query? Explain

959

---

What is the most common sql injection tool?

993

---

Explain the advantages and disadvantages of stored procedure?

1075

---

What are the advantages of stored procedure?

945

---

List the various privileges that a user can grant to another user?

988

---

Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

2069

---

How is data stored on a disk?

961

---

Why primary key is required?

936

---

Why coalesce is used in sql?

916

---

define join and explain different type of joins? : Sql dba

897

---

What are literals in sql server?

1071

---

what is a tablespace? : Sql dba

1004

---