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 in oracle?

1063

What is before and after trigger?

960

Can unique keys be null?

913

How can we avoid duplicating records in a query?

983

What is the function that is used to transfer a pl/sql table log to a database table?

1023

What is the need of a partition key?

987

What is dml statement?

957

how to get @@error and @@rowcount at the same time? : Sql dba

1028

What is sql query optimization?

1122

Is microsoft sql free?

1105

Is sql the best database?

976

What is the use of prepared statement?

1025

How to convert comma separated string to array in pl/sql?

1185

Is there any restriction on the use of union in embedded sql?

1158

What is the difference between null value, zero, and blank space?

1207