What are joins..how many types of joins are there?

Answer Posted / niranjan.b

In sql joins are 3 types
1.Inner join
2.Outer join
a)left outer join
b)right outer join
c)full outer join
3.Cross join

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

1448


What is meant by recursive hints in oracle?

620


How to define a variable to match a table column data type?

580


How to create a new tablespace in oracle?

560


How to define a procedure inside another procedure?

545






What is the data pump export utility?

646


How much memory your 10g xe server is using?

582


How to load data through external tables?

583


Explain an index segment?

645


What are temporal data types in oracle?

598


How to connect the oracle server as sysdba?

633


what is meant by magic query

1775


What is a oracle database?

609


you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1564


What are oracle functions?

553