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

Which function is used to return remainder in a division operator in sql?

1142

define sql insert statement ? : Sql dba

1031

what is data integrity? : Sql dba

1038

What is the size of partition table?

1048

explain primary keys and auto increment fields in mysql : sql dba

978

what is a cursor? : Sql dba

1025

what is union, minus and interact commands? : Sql dba

1186

What is parameter substitution in sql?

1030

what are the different type of sql's statements ? : Sql dba

926

What is substitution variable in pl sql?

1046

How to get help at the sql prompt?

1116

Is pl sql better than sql?

1036

explain advantages of myisam over innodb? : Sql dba

1069

How would you reference column values before and after you have inserted and deleted triggers?

1065

What is the difference between python and sql?

1005