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

How many types of sql are there?

719

how to convert dates to character strings? : Sql dba

726

What is normalization in a database?

843

What is pl sql quora?

817

Explain locks? : Transact sql

738

Is vs as in pl sql?

668

what is oltp (online transaction processing)? : Sql dba

718

How do I order columns in sql?

696

Can we commit in trigger?

696

what are the disadvantages of mysql? : Sql dba

761

Does sap use sql?

715

Define select, insert, create, delete, update, drop keywords

776

What is composite data type in pl sql?

762

What are predefined functions in sql?

707

What is program debugging?

761