5 types 1) Equi join 2) cartesian join 3) non-equi join 4)outer join(+)

Types of joins ?

Question Posted / lakshminrayana reddy

Answer Posted / lakshminrayana reddy

5 types
1) Equi join
2) cartesian join
3) non-equi join
4)outer join(+)
i)left outer join
ii) right outer join
5)self join

Is This Answer Correct ?

5 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is the difference between delete, truncate and drop command?

1126

What are conditional predicates?

1031

Is left join same as join?

971

Can we use commit inside a trigger?

1069

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1045

what is a database lock ? : Sql dba

1150

Define commit?

979

What is restrict in sql?

1090

what are the authentication modes in sql server? : Sql dba

1041

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

934

How to get unique records from a table?

941

Why do we use joins in sql?

956

What is sql indexing?

998

Explain what is table in a database?

1045

what are the differences among rownum, rank and dense_rank? : Sql dba

1027