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 many triggers are allowed in mysql table? : Sql dba

556


How to avoid using cursors? What to use instead of cursor and in what cases to do so?

596


What is the difference between rename and alias?

705


What is sql profiler in oracle?

559


What is trigger in pl sql?

555






how to install mysql? : Sql dba

580


What is sql query optimization?

541


What are literals in sql server?

526


What is bulk collect in pl sql?

528


Which join is default?

519


Which is faster subquery or join?

656


What are the differences between in and exists clause?

564


What is spool?

588


Does pdo prevent sql injection?

520


What is user in sql?

575