Answer Posted / sreekanth

Basically there are 5 types of joins, they are

1.Equi join
2.Non-equi join
3.cartegian join
4.outer join(+)>>a)left outer join
b)right outer join
5.self join

what's the difference between a primary key and a unique key? : Sql dba

971

---

How do sql triggers work?

987

---

Is there a 64 bit version of ssms?

893

---

how to fetch common records from two tables? : Sql dba

1105

---

How do I view a view in sql?

889

---

What are operators available in sql?

978

---

What is sql and explain its components?

1007

---

What is fmtonly in sql?

1008

---

what are dynamic queries in t-sql? : Transact sql

961

---

how to create a new table by selecting rows from another table in mysql? : Sql dba

1007

---

What is trigger in sql? Explain

941

---

Does sql support programming?

1007

---

Can we join tables without foreign key?

908

---

How to run sql statements through the web interface?

984

---

How to use transactions efficiently : transact sql

991

---