Answer / m4io

a cartesian product is a join between two tables where
the join-condition + where-conditions do not deliver a
unique key on either table.
it is a n*m relationship.

Not necessarily faulty (Star joins use cartesian products)

Answer / sunil1405

A Cartesian product results from a faulty query. It is a
row in the results for every combination in the join
tables.

What is collection in db2 bind?

1 Answers  

---

What is meant by repeatable read?

4 Answers  

---

Mention data types used in db2 ?

1 Answers  

---

What is the difference between nvl and coalesce?

1 Answers  

---

What is a Foreign Key?

1 Answers   Tavant Technologies, Zensar,

---

What is the use of commit in db2?

1 Answers  

---

Why db2 is called db2?

1 Answers  

---

how we will do null data selection in cobol-db2 program

2 Answers   Wipro,

---

List out the data types available.

1 Answers  

---

What is the use of with ur in db2?

1 Answers  

---

What is with ur in db2?

1 Answers  

---

I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?

6 Answers   Perot Systems,

---