what are the different types of joins?

Answer Posted / prakash

Proprietary Joins
----------------
EquiJoin
Non EquiJoin
Self Join
outer join

Compliant Joins
---------------
Cross Join
Natural Joins
Full or two sided outer joins
Arbitrary Joins

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is json a nosql?

533


How do sql triggers work?

546


What is the difference between an inner join and an outer join?

511


What is sap sql?

530


What is cost in sql execution plan?

482






What is the least restrictive isolation level? : Transact sql

561


how to use 'mysql' to run sql statements? : Sql dba

535


Is sql procedural language?

548


What is a unique key?

582


Are subqueries better than joins?

525


What do you understand by exception handling in pl/sql?

571


Explain the types of joins in sql?

567


How long it takes to learn pl sql?

527


How many types of sql are there?

518


How do I find duplicates in sql?

499