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

Can we insert data in view?

956

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

1004

What are the different types of constraints?

1176

What are sql commands?

1010

explain what is mysql? : Sql dba

1079

Is vs as in pl sql?

984

What is Histogram?

1554

Is sql a case sensitive language?

937

How do you update a sql procedure?

1025

How to get help at the sql prompt?

1111

What are the different types of dbmss?

1013

What does desc stand for?

1065

What is left join in sql?

1043

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

1205

Explain spool.

1176