What are different types of joins ?

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

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how mysql optimizes distinct? : Sql dba

555


What is partition in sql query?

519


Is sql open source?

545


What are the sql versions?

522


What is an exception in pl/sql?

544






Can we delete column in sql?

563


what is the bond code in materialized view?

2489


Is ms sql traffic encrypted?

505


Is sql procedural language?

554


explain primary keys and auto increment fields in mysql : sql dba

535


What are conditional predicates?

587


Can you join views in sql?

544


What is rownum and rowid?

570


What are the types of queries in sql?

524


Is sql a dbms?

536