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

What are different clauses used in sql?

1103

what is an extent ? : Sql dba

1070

How do I copy a table in sql?

964

What is db journal file?

1033

Which is better join or inner query?

1014

What are aggregate functions in sql?

1136

What is sql analyzer?

995

what are the limitations of identity column? : Transact sql

1087

What mean sql?

991

What does rownum mean in sql?

1008

What are system versioned tables?

1008

How do I order columns in sql?

965

How delete all records from table in sql?

958

What is cursor explain with example?

964

What is union and union all keyword in sql and what are their differences?

1082