What is a join query?

0 Answers  

---

What is the difference between left join and left outer join?

1 Answers  

---

how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc

1 Answers   IAS,

---

What is the Subquery?

4 Answers  

---

what is self join and what is the requirement of self join? : Sql dba

0 Answers  

---

Why we use sql profiler?

0 Answers  

---

how can we find the number of rows in a table using mysql? : Sql dba

0 Answers  

---

how are mysql timestamps seen to a user? : Sql dba

0 Answers  

---

I have a tablle like this. cust acc --------------- a 1 b 2|3 c 4|5|6 I Want below o/p: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 Please any one can you have any ideas share me. I have urgent requirement.

4 Answers   Cap Gemini, MTS,

---

What is the best sql course?

0 Answers  

---

How will we see framework of a table?

2 Answers   Accenture,

---

What are hotfixes and patches?

0 Answers  

---