2 types 1)inner join , 2)outer join a)left outer b)right outer c

Types of joins ?

Question Posted / vinodkumar.r

Answer Posted / vinodkumar.r

2 types
1)inner join ,
2)outer join
a)left outer
b)right outer
c)full outer

Is This Answer Correct ?

7 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How can check sql version from command line?

1087

What is scalar data type in pl sql?

1070

Define sql delete statement.

1016

what are the authentication modes in sql server? How can it be changed? : Sql dba

1433

What is the use of count (*) in sql?

1054

Why do we create views in sql?

1154

How do you modify a column in sql?

999

what is timestamp in mysql? : Sql dba

1077

What are the syntax and use of the coalesce function?

1206

Does a user_objects view have an entry for a trigger?

1012

Is it possible to pass parameters to triggers?

1103

What is an intersect?

1103

Does sql use python?

1035

What is raid? How does it help storage of databases?

1087

What will you get by the cursor attribute sql%rowcount?

1038