5 types 1) Equi join 2) cartesian join 3) non-equi join 4)outer join(+)

Types of joins ?

Question Posted / lakshminrayana reddy

Answer Posted / lakshminrayana reddy

5 types
1) Equi join
2) cartesian join
3) non-equi join
4)outer join(+)
i)left outer join
ii) right outer join
5)self join

Is This Answer Correct ?

5 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is an index in sql with example?

969

What are the possible values for the boolean data field?

961

How are functions and procedures called in PL/SQL?

1224

What is a design view?

921

What are different types of keys?

1100

Is it possible to create startup or shutdown trigger for on-schema?

1021

Is ms sql is free?

1020

Which is better join or subquery?

1134

What is full form of rtm?

1003

How long it takes to learn pl sql?

1010

How to use sql*plus built-in timers?

1194

What is record variable?

986

What is the difference between a database and a relational database?

1097

what is the difference between clustered and non clustered index in sql? : Sql dba

1123

What problem one might face while writing log information to a data-base table in pl/sql?

1157