1)Inner Join a)Equi join b)Natural Join c)Cross Join 2)Outer Join

Types of joins ?

Question Posted / anuadarsh

Answer Posted / anuadarsh

1)Inner Join
a)Equi join
b)Natural Join
c)Cross Join
2)Outer Join
a)Left join
b)Right join
c)Full join
3)Self Join

Is This Answer Correct ?

3 Yes

2 No

Please Help Members By Posting Answers For Below Questions

what are the disadvantages of mysql? : Sql dba

1154

What is data control language?

999

What is case function?

1045

Why do we need sharding?

1005

Why is %isopen always false for an implicit cursor?

1121

Explain the difference between drop and truncate commands in sql?

1070

Define concurrency control. : Transact sql

1195

When to use inner join and left join?

971

What company owns postgresql?

1039

Does a join table need a primary key?

964

What are local and global Indexes and where they are useful.

1450

what is acid property in database? : Sql dba

1041

Is foreign key mandatory?

1016

What is the process of debugging?

1081

What is the most restrictive isolation level? : Transact sql

1095