Types of joins?

Answer Posted / roopesh kumar

(1) Inner or Equei join
(2) Outer or no - equei join
(a) left outer
(b) right outer
(c) full outer
(3) Cartision or cross join
(4) Self join
(5) Natural join

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

define sql delete statement ? : Sql dba

566


what is a composite primary key ? : Sql dba

583


What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

554


What is full form of rtm?

535


Is postgresql a server?

577






What are sql functions? Describe in brief different types of sql functions?

494


What is a boolean in sql?

526


What does select count (*) mean in sql?

556


Does a user_objects view have an entry for a trigger?

573


Explain the savepoint statement.

604


Is it possible for a table to have more than one foreign key?

582


Is left join same as join?

524


Does user triggers have entry for trigger with compilation errors?

602


What packages are available to pl/sql developers?

605


What are three advantages to using sql?

555