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 is transaction? : Sql dba

1058

how to show all tables with 'mysql'? : Sql dba

1156

Which is the correct statement about truncate and delete?

1169

How do rank () and dense_rank () differ?

1105

What is dml statement?

999

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3103

Is foreign key mandatory?

1064

What are the different sql languages?

1090

What happens when a trigger is associated to a view?

970

Can we use view in stored procedure?

953

Can we join same table in sql?

1066

How do I run a pl sql program?

1189

How to set up sql*plus output format in oracle?

1079

What is primary and foreign key?

1120

what are the advantages of using stored procedures? : Sql dba

1148