1) SELF JOIN 2) EQUI JOIN(OR) INNER JOIN 2.1) NON-EQUI JOIN 3)OUTER JO

Types of joins ?

Question Posted / a.jyothsna

Answer Posted / a.jyothsna

1) SELF JOIN
2) EQUI JOIN(OR) INNER JOIN
2.1) NON-EQUI JOIN
3)OUTER JOIN
3.1) LEFT OUTER JOIN
3.2) RIGHT OUTER JOIN
3.3) FULL OUTER JOIN

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is recursive join in sql?

1031

what is a control file ? : Sql dba

1045

what are the performance and scalability characteristics of mysql? : Sql dba

1000

How do you write a complex sql query?

1092

What are the types pl/sql code blocks?

1137

What are all different types of collation sensitivity?

1035

What is sql constant?

1039

What are some predefined exceptions in pl/sql?

1173

What is linq to sql?

1139

How do you use a while loop in pl sql?

1015

What is a boolean in sql?

985

What is the sql*loader? : aql loader

1058

how to convert numeric values to character strings? : Sql dba

1110

What is the use of nvl function?

1202

How many types of tables are there?

954