1.Equi join 2.Natural Join 3.cartegian/cross/non-equi join 4.outer join(

What are different types of joins ?

Question Posted / amit das

Answer Posted / amit das

1.Equi join
2.Natural Join
3.cartegian/cross/non-equi join
4.outer join(+)>>a)left outer join
b)right outer join
5.self join

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is sql not null constraint?

1023

what is view? : Sql dba

953

What is rowtype?

1012

Can a key be both primary and foreign?

991

How do you create a unique index?

1044

What are different types of statements supported by sql?

1162

What is a database trigger?

1065

What is meant by truncate in sql?

1060

What are the different types of joins in sql?

1778

Is hadoop a nosql?

996

What is record variable?

982

How do I filter in sql profiler?

990

What normalization means?

968

What are tables and fields in the database?

1104

What does inner join mean?

1156