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 exit statement?

1015

What is pl sql and why it is used for?

1113

Does varchar need length?

991

Can we call stored procedure in function?

958

Why truncate is used in sql?

1005

Is and as keyword in pl sql?

961

How do I order by ascending in sql?

1020

What is substitution variable in pl sql?

1044

Explain character-manipulation functions?

1133

Is clustered index a primary key?

949

What is the clause we need to add in function body to return variable?

1012

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

1059

What is database white box testing and black box testing?

1111

Mention what plvcmt and plvrb does in pl/sql?

1143

Can a foreign key have a different name?

940