I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p if we perform equijoin,outer join,right outer join,left outer join,full outer join,cross join seperately Can anyone help on this?

2 Answers  

---

What is the benefit of foreign key?

0 Answers  

---

What is query optimization in sql?

0 Answers  

---

How do you create a unique index?

0 Answers  

---

In what condition is it good to disable a trigger?

0 Answers  

---

How do I trace sql profiler?

0 Answers  

---

how to give permission to users that users can update/insert/delete on a row of table on timeing 10am to 6pm only?

4 Answers   TCS,

---

What does trigger mean in psychology?

0 Answers  

---

what is data control language? : Sql dba

0 Answers  

---

take one table is t1 and in that column name is f1 f1 column values are 200 5000 3000 7000 300 600 100 400 800 400 i want display the values asc and desc in a single output. sample output is f1.a 100 200 300 400 500 600 etc...... and f1.d is 5000 4000 3000 2000 1000 etc...

9 Answers   Zensar,

---

Types of backups ?

3 Answers   TCS,

---

what is constraining table?

2 Answers  

---