I have 2 table A and B. In A 1 lakh record is present. In b 20 thousand data is present. To get the unique data from table A and B which join we should prefer left inner join or right outer join. Please answer.

4 Answers   GE,

---

What view means?

0 Answers  

---

State few characteristics of pl/sql?

0 Answers  

---

How do I upgrade sql?

0 Answers  

---

What are the types of variable use in pl sql?

0 Answers  

---

---

Can we use commit inside a trigger?

0 Answers  

---

What are the different tcl commands in sql?

0 Answers  

---

Write a sql select query that only returns each name only once from a table?

0 Answers  

---

How many types of cursors supported in pl/sql?

0 Answers  

---

Why left join is used in sql?

0 Answers  

---

What can sql server reporting services do?

0 Answers  

---

How to add Foreign key in a table after the creation of the table?

5 Answers   Satyam,

---