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

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

Question Posted / niranjan.b

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

Please Help Members By Posting Answers For Below Questions

Whether any commands are used for months calculation? If so, what are they?

1099

Explain about functional dependency and its relation with table design?

1013

What is meant by a deadlock situation?

1111

Explain oracle’s server parameter file.

997

How to pass parameters to procedures in oracle?

1042

Please explain compound trigger in oracle?

1062

How to load data through external tables?

1140

Explain cascading triggers.

1077

How to find out what oracle odbc drivers are installed?

1043

How to list all user accounts in oracle?

1029

What is sequence?

1087

What is a initialization parameter file in oracle?

1039

How many types of database triggers exist?

1136

What is tns entry?

1156

How to get the Installed Oracle Version Information ?

1126