hai 1.Equi Join 2.Non-Equi Join 3.Cartesian Join 4.outer Join(+)(Left O

Types of joins ?

Question Posted / ganesh

Answer Posted / ganesh

hai
1.Equi Join
2.Non-Equi Join
3.Cartesian Join
4.outer Join(+)(Left Outer Join/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 cross join example?

989

What is sql and explain its components?

1057

What is difference between joins and union?

1119

What is the difference between in and between in sql?

1055

how many ways to get the current time? : Sql dba

1001

How many types of cursors supported in pl/sql?

1184

Why left join is used in sql?

977

How do I count rows in sql query?

986

What are the topics in pl sql?

969

Can a select statement fire a trigger?

1153

Can you do multiple joins in sql?

1047

How to call shell script from pl sql procedure?

1275

What is sql query limit?

975

how to select unique records from a table? : Sql dba

1111

What is synchronized subquery?

1164