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

Is join and inner join the same?

942

Explain clause in sql?

962

What are literals in sql server?

1075

What is the difference between sum and count in sql?

938

What are the 3 types of behavioral triggers?

1184

What is recursive join in sql?

948

What is a join?

1021

Is id a reserved word in sql?

1093

Can cursors be part of a trigger body?

1588

How do you copy a table in sql?

1015

How do I enable sql encryption?

969

How many types of indexes are there in sql?

935

What are the different types of a subquery?

984

What is t sql used for?

974

is it possible to pass an object or table to a procedure as an argument?

1062